Seagul

Lesson 3 - Duplicate titles and most used title

Dataset statusEasy SQL exercisesvv1

Exercise content

In the books table:

count how many titles appear more than once
find which title is used the most

Return:

duplicate_titles
most_used_title
title_count

Hints

Hint 1

Start by grouping books by book_name. For each title, calculate how many times it appears.
Hint 2

One part should count the titles with a count greater than 1. Another part should find the title with the highest count.
Hint 3

In the end you need a single row with different statistics. Think of two sub-results combined together.

Not completed

Loading dataset...

Latest result

No result set available.