Group and order fields
After reviewing your country analysis, the team is eager for more insights.
This time they want to understand production trends over time: which years produced the most films? Spotlighting the busiest years makes it easier to design festival themes around eras with the richest selection of films.
Deze oefening maakt deel uit van de cursus
Intermediate SQL with AI
Oefeninstructies
- Write a prompt to find the top 5 years with the most films, listed from highest to lowest.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT release_year
FROM films;