CREATE TABLE LOCATIONS (Location_Name VARCHAR)

Which location names contain the word 'film'?
SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"
SELECT "Location_Name" FROM "LOCATIONS" WHERE "Location_Name" LIKE "%film%"