What are the names and descriptions of the photos taken at the tourist attraction "film festival"?
create table tourist_attractions (tourist_attraction_id varchar, name varchar, PRIMARY KEY (tourist_attraction_id)); create table photos (name varchar, description varchar, tourist_attraction_id varchar, PRIMARY KEY (name))
select t1.name, t1.description from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t2.name = "film festival"