How many tourist attractions can be reached by bus?
select count(*) from tourist_attractions where how_to_get_there = "bus"
How about the number of tourist attractions that can be reached by bus or are at address 254 Ottilie Junction?
select count(*) from locations as t1 join tourist_attractions as t2 on t1.location_id = t2.location_id where t1.address = "254 ottilie Junction" or t2.how_to_get_there = "bus"
Please show the names of these tourist attractions.
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" or t2.how_to_get_there = "bus"