Show all the films longer than 100 minutes? | do  you  mean  the films id  ? | yes
SELECT film_id FROM film WHERE LENGTH > 100
films longer than 100 minutes refers to LENGTH > 100; showing films id refers to SELECT film_id;