How many people choose to get to the tourist attractions by walking?
select count(*) from tourist_attractions where how_to_get_there = "walk"
How about by bus?
select count(*) from tourist_attractions where how_to_get_there = "bus"
Then, which transportation method is the most popular?
select how_to_get_there from tourist_attractions group by how_to_get_there order by count(*) desc limit 1