How many tourist attractions are there?
select count(*) from tourist_attractions
How many of them are associated with the photo "fun1"?
select count(*) from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "fun1"
How about the photo "game1"?
select count(*) from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"
Please show the name of these tourist attractions?
select t2.name from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t1.name = "game1"