Categorize with aggregates
The finance department has raised concerns about missing film revenue data. To prioritize cleanup, they need a year-by-year summary that separates films with reported gross revenue from those without. This analysis will help them focus their resources on the years with the biggest data issues.
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
Pokyny k cvičení
- Write a prompt that selects the release year, counts films with missing gross values, counts films with non-missing gross values, groups by release year, and orders the results chronologically by release year.
- Name the new categories as
films_with_grossandfilms_without_gross.
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;