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.
Diese Übung ist Teil des Kurses
Intermediate SQL with AI
Anleitung zur Übung
- Write a prompt to find the top 5 years with the most films, listed from highest to lowest.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT release_year
FROM films;