Seagull

Lesson 8 - 6. Netflix counts by year with a CTE

Dataset statusEasy SQL exercisesvv1

Exercise content

Use a CTE named views_by_year to count how many contents were watched in each year in the netflix_history table.

The final result must show these columns:

year
total_views

Order by year ascending.

Hints

Hint 1
A CTE is written with WITH name AS (...).
Hint 2
You can extract the year with substr(date, 1, 4).

Not completed

Loading dataset...

Latest result

No result set available.