Finding averages and totals
You are analyzing the film library to prepare for an executive summary report. You need to calculate the average and total film durations per year to understand how much content is available across the library and to help select a year that can be featured at an upcoming festival. This analysis will give executives a clear picture of both the scale and characteristics of the film catalog across different time periods.
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;