7 kyu
Best-Selling Books (SQL for Beginners #5)
24,383 of 24,386MaikelNabil
Description:
You work at a book store. It's the end of the month, and you need to find out the 5 bestselling books at your store. Use a select statement to list names, authors, and number of copies sold of the 5 books which were sold most.
books table schema
- name
- author
- copies_sold
NOTE: Your solution should use pure SQL. Ruby is used within the test cases just to validate your answer.
SQL for Beginners Series
This kata is part of a collection of SQL challenges for beginners. You can take the rest of the challenges here:
Fundamentals
SQL
Databases
Similar Kata:
Stats:
Created | May 9, 2017 |
Published | May 9, 2017 |
Warriors Trained | 28574 |
Total Skips | 1138 |
Total Code Submissions | 54449 |
Total Times Completed | 24386 |
SQL Completions | 24383 |
Total Stars | 88 |
% of votes with a positive feedback rating | 93% of 2364 |
Total "Very Satisfied" Votes | 2052 |
Total "Somewhat Satisfied" Votes | 278 |
Total "Not Satisfied" Votes | 34 |
Total Rank Assessments | 36 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 2 kyu |
Lowest Assessed Rank | 8 kyu |