yes
select tourist_attraction_id,location_id,name from tourist_attractions where how_to_get_there = 'bus'
can you show me a list of location id?
select location_id from tourist_attractions
i want to learn attraction type code?
select location_id,attraction_type_code from tourist_attractions