How many shops are there?
select count(*) from shops
How many of them could be accessed by bus?
select count(*) 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 the number of those that could be accessed by walking?
select count(*) from shops as t1 join tourist_attractions as t2 on t1.shop_id = t2.tourist_attraction_id where t2.how_to_get_there = "walk"
Please show the details of these shops.
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"