What are the names of the tourist attractions that can be accessed by bus or walk?
select name from tourist_attractions where how_to_get_there = "bus" or how_to_get_there = "walk"
What are their opening hours, please?
select name, opening_hours from tourist_attractions where how_to_get_there = "bus" or how_to_get_there = "walk"
What are the names of the tourist attractions that can be accessed by shuttle?
select name from tourist_attractions where how_to_get_there = "shuttle"
What are their opening hours?
select name,opening_hours from tourist_attractions where how_to_get_there = "shuttle"
What are the location ids of those?
select name,location_id from tourist_attractions where how_to_get_there = "shuttle"