Counting films by budget range
You are analyzing the distribution of film budgets since the year 2000. You want a yearly breakdown of how many films fall into three budget tiers: over 100 million, between 20 and 100 million, and under 20 million. You also want to see only years with enough data points to be reliable. Approach this problem step by step.
To ćwiczenie jest częścią kursu
Intermediate SQL Querying with AI
Interaktywne ćwiczenie praktyczne
Spróbuj tego ćwiczenia, uzupełniając ten przykładowy kod.
SELECT
release_year
FROM films
GROUP BY release_year
ORDER BY release_year;