Table 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%"