Counting top-rated films
You are launching a “Critics’ Choice” section to showcase premium content and boost subscriber engagement. This curated collection will help viewers discover exceptional films and set you apart from competitors.
To prepare it, you need to know how many films scored higher than 8.0 on IMDb.
This exercise is part of the course
Intermediate SQL with AI
Exercise instructions
- Write a prompt that filters the reviews table and counts the film IDs for films with IMDb scores higher than 8.0.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT *
FROM reviews;