Seagull

Lesson 8 - 2. Subquery: book_id rated 4 by user 550

Dataset statusEasy SQL exercisesvv1

Exercise content

Find the list of book_id values rated by user_id = 550 with vote = 4.

Didactic constraint: use a subquery.

Hints

Hint 1
The subquery must find the book_id values where user_id = 550 and vote = 4. That list will be used by the outer query.
Hint 2
In the main query, filter with book_id IN (subquery). Show only one column, book_id, and order by book_id.

Not completed

Loading dataset...

Latest result

No result set available.