Seagull

Lesson 3 - 29. Netflix show with the longest title

Dataset statusEasy SQL exercisesvv1

Exercise content

Find the longest non-null title in the netflix_history table.

Show title and title_length, order by title_length DESC, title ASC, and limit the result to a single row.

Hints

Hint 1
SQLite has the LENGTH(...) function. You can use it on the title field to get title_length.
Hint 2
First filter with title IS NOT NULL. Then sort by length descending, in case of ties by title, and do LIMIT 1.

Not completed

Loading dataset...

Latest result

No result set available.