Seagull

Lesson 8 - 7. Top Netflix year and content watched per month

Dataset statusEasy SQL exercisesvv1

Exercise content

Find the year in which you watched the highest number of items in netflix_history.

Then show, for that year, the number of items watched in each month.

Required output:

month (format MM)
total_views

Hints

Hint 1
Work in two steps. First count how many rows there are for each year extracted from date.
Hint 2
Put the count by year in a first CTE. In a second CTE, select only the year with the highest total.
Hint 3
Filter netflix_history by the year you found. Then extract the month with substr(..., 6, 2) and do COUNT(*) by month.

Not completed

Loading dataset...

Latest result

No result set available.