Seagull

Lesson 3 - 16. Duplicate titles

Dataset statusEasy SQL exercisesvv1

Exercise content

In the books table, find the titles that appear more than once.

For each duplicate title, return:

book_name
title_count

Order by:

title_count descending
book_name ascending

Hints

Hint 1
Group the rows in the books table by book_name.
Hint 2
For each group, use COUNT(*) and name it title_count.
Hint 3
After GROUP BY, use HAVING COUNT(*) > 1 to keep only duplicate titles.

Not completed

Loading dataset...

Latest result

No result set available.