Seagull

Lesson 4 - 7. Create easy_pearson_book Table

Dataset statusEasy SQL exercisesvv1

Exercise content

Create a table called easy_pearson_book containing the books published by Pearson that have Easy in the title.

The table must not contain duplicate titles.

Hints

Hint 1
You only need books with publisher = 'Pearson'. Also, the title must contain the word Easy.
Hint 2
The final check looks for duplicates on book_name. So you need to group or deduplicate by title.

Not completed

Loading dataset...

Latest result

No result set available.