Seagul

Lesson 3 - Year with the most content watched

Dataset statusEasy SQL exercisesvv1

Exercise content

Using the netflix_history table, find the year with the highest number of views.

Show the columns:

year
total_views

Order by total_views DESC, year DESC and return only one row.

Hints

Hint 1

The date column contains a full date. Extract only the first 4 characters and call them year.
Hint 2

After extracting the year, group by year. Then count how many rows belong to each year.
Hint 3

Sort by total_views DESC and, in case of ties, by year DESC. Finally return only one row.

Not completed

Loading dataset...

Latest result

No result set available.