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.
Bu egzersiz
Intermediate SQL with AI
kursunun bir parçasıdırEgzersiz talimatları
- Write a prompt to find the top 5 years with the most films, listed from highest to lowest.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT release_year
FROM films;