How can I get to the tourist attraction "film festival"?
select how_to_get_there from tourist_attractions where name = "film festival"
How many photos have been taken at this tourist attraction?
select count(*) from photos as t1 join tourist_attractions as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id where t2.name = "film festival"
Please show its name and descriptions.
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"