SCHEMA:
CREATE TABLE film (title VARCHAR)
USER:
How many films have the word 'Dummy' in their titles?

QUERY:
SELECT COUNT(*) FROM film WHERE title LIKE "%Dummy%"