Netflix's content strategy team wants a quick look at where its titles come from, and how long the movies from each country tend to be.
For each country, show the number of titles (movies and series) and the average length of its movies in minutes.
Expected output
avg_movie_minutes rounded to 1 decimal; any row orderExample of the shape (made-up values):
| country | titles | avg_movie_minutes |
|---|---|---|
| Canada | 6 | 121.5 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.