SCHEMA:
CREATE TABLE film (Id VARCHAR)
USER:
How many film are there?

QUERY:
SELECT COUNT(*) FROM film