Seagul

Lesson 5 - Books without votes with book_id and name

Dataset statusEasy SQL exercisesvv1

Exercise content

Using the books and book_stars tables, find the books in books that have not received any votes in book_stars.

Return the columns:

book_id
book_name

Order by book_id and use an explicit JOIN.

Hints

Hint 1

The main table must be books. Then connect book_stars with a LEFT JOIN.
Hint 2

After the LEFT JOIN, books without votes will have null fields on the book_stars side. Filter those rows with IS NULL.

Not completed

Loading dataset...

Latest result

No result set available.