Seagull

Lesson 8 - 16. View of the Top 10 Books by Total Votes

Dataset statusEasy SQL exercisesvv1

Exercise content

Create the view fp_top10_books_votes using the book_stars table.

The view must contain the 10 book_id values with the highest sum of vote.

Show these columns:

book_id
total_vote

Sort by total_vote DESC, book_id ASC and limit the result to 10 rows.

Hints

Hint 1
The starting table is book_stars. For each book_id, you need to calculate the sum of vote.
Hint 2
After the aggregation, sort from the highest total to the lowest. In case of a tie, use ascending book_id and keep only 10 rows.

Not completed

Loading dataset...

Latest result

No result set available.