How many tourist attractions are there at address 660 Shea Crescent?
select count(*) from locations as t1 join tourist_attractions as t2 on t1.location_id = t2.location_id where t1.address = "660 shea Crescent"
How many tourist attractions can be reached by walking?
select count(*) from tourist_attractions where how_to_get_there = "walk"
Please show the names of these tourist attractions or those that are at address 660 Shea Crescent.
select t2.name from locations as t1 join tourist_attractions as t2 on t1.location_id = t2.location_id where t1.address = "660 shea Crescent" or t2.how_to_get_there = "walk"