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.
Deze oefening maakt deel uit van de cursus
Intermediate SQL with AI
Oefeninstructies
- Write a prompt that filters the reviews table and counts the film IDs for films with IMDb scores higher than 8.0.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT *
FROM reviews;