Finding short films
For a family movie night, it's important to pick films that don't run too long. This helps families enjoy the full experience without late nights.
Your task is to filter the catalog for films that are 90 minutes or shorter, which will help improve the collection.
This exercise is part of the course
Intermediate SQL with AI
Exercise instructions
- Construct a prompt that selects the film title and duration for films that are 90 minutes or less.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT *
FROM films;