How many markets are there?
select count(*) from street_markets
How many of them could be accessed by shuttle?
select count(*) from street_markets as t1 join tourist_attractions as t2 on t1.market_id = t2.tourist_attraction_id where t2.how_to_get_there = "shuttle"
How about the number of those that could be accessed by walking or bus?
select count(*) from street_markets as t1 join tourist_attractions as t2 on t1.market_id = t2.tourist_attraction_id where t2.how_to_get_there = "walk" or t2.how_to_get_there = "bus"
Please show the details of these markets.
select t1.market_details from street_markets as t1 join tourist_attractions as t2 on t1.market_id = t2.tourist_attraction_id where t2.how_to_get_there = "walk" or t2.how_to_get_there = "bus"