Filtering averages
You are analyzing movie durations across the globe. You're interested in understanding what the average duration is in each country and to isolate any countries that prefer shorter-form films. This will help you understand any cultural trends in film production.
This exercise is part of the course
Intermediate SQL with AI
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT country
FROM films;