how many shops are there?
select count ( * ) from shops
what kinds of shops are they?
select shop_details from shops
Can any one of them be accessed by bus?
select t1.shop_id from shops as t1 join tourist_attractions as t2 on t1.shop_id = t2.tourist_attraction_id where t2.how_to_get_there = "bus"
how about by walk?
select t1.shop_id from shops as t1 join tourist_attractions as t2 on t1.shop_id = t2.tourist_attraction_id where t2.how_to_get_there = "walk"
What kind of shop is that?
select t1.shop_details from shops as t1 join tourist_attractions as t2 on t1.shop_id = t2.tourist_attraction_id where t2.how_to_get_there = "walk"