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.
Diese Übung ist Teil des Kurses
Intermediate SQL with AI
Anleitung zur Übung
- Write a prompt that filters the reviews table and counts the film IDs for films with IMDb scores higher than 8.0.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT *
FROM reviews;