How many films have the word 'Dummy' in their titles?
SELECT count(*) FROM film WHERE title LIKE "%Dummy%"
films have the word 'Dummy' in their titles refers to title LIKE '%Dummy%'; counting films refers to COUNT(*);