Seagul

Lesson 10 - Books without votes using a subquery

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.

Learning constraint: use a subquery on book_stars.

Hints

Hint 1

The subquery must read from book_stars. You need the list of book_id values present there.
Hint 2

In the outer query’s WHERE, keep the books whose book_id does not appear in the subquery. Then order by book_id.

Not completed

Loading dataset...

Latest result

No result set available.