What is the name of the tourist attraction that is associated with the photo "game1"?
create table tourist_attractions (name varchar, tourist_attraction_id varchar, PRIMARY KEY (name)); create table photos (tourist_attraction_id varchar, name varchar, PRIMARY KEY (tourist_attraction_id))
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"