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 titles.
This exercise is part of the course
Intermediate SQL with AI
Exercise instructions
- Write a prompt to find the top 5 years with the most films, listed from highest to lowest.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT release_year
FROM films;