Filtering totals
Longer films need more subtitle capacity. You'll identify languages with the longest average durations to forecast this effort and help the team allocate resources more efficiently. By focusing on languages with consistently long films in recent years, the company can plan budgets and staffing with fewer surprises. You'll have part of the query ready for you, your job is to iterate on it to add the appropriate filters.
Toto cvičení je součástí kurzu
Intermediate SQL Querying with AI
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
language,
AVG(duration) AS avg_duration
FROM films
WHERE duration IS NOT NULL
GROUP BY language;