Schema: CREATE TABLE LOCATIONS (Location_Name VARCHAR)
Question: Which location names contain the word "film"?
SQL: SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"