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.
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
Pokyny k cvičení
- Write a prompt to find the top 5 years with the most films, listed from highest to lowest.
Interaktivní cvičení na vyzkoušení si v praxi
Vyzkoušejte si toto cvičení dokončením tohoto ukázkového kódu.
SELECT release_year
FROM films;