Can you list the names of all the tourist attractions?
select name from tourist_attractions
Hmm, I want to know the names of the tourist attractions that can be reached by bus.
select name from tourist_attractions where how_to_get_there = "bus"
Can you also tell me the name of the tourist attraction that is at address 254 Ottilie Junction?
select t2.name from locations as t1 join tourist_attractions as t2 on t1.location_id = t2.location_id where t1.address = "254 ottilie Junction"
Can you list the location names of the tourist attractions that can be reached by bus?
select t1.location_name from locations as t1 join tourist_attractions as t2 on t1.location_id = t2.location_id where t2.how_to_get_there = "bus"
Can you list the location addresses?
select t1.address from locations as t1 join tourist_attractions as t2 on t1.location_id = t2.location_id where t2.how_to_get_there = "bus"