Problem

Given a table of products, write a stored procedure that returns the top 10 products by sales.
Example input:
| product_id | name       | sales |
|------------|------------|-------|
| 1          | Product 1  | 10    |
| 2          | Product 2  | 20    |
| 3          | Product 3  | 30    |
| 4          | Product 4  | 40    |
| 5          | Product 5  | 50    |
Example output:
| product_id | name       | sales |
|------------|------------|-------|
| 5          | Product 5  | 50    |
| 4          | Product 4  | 40    |
| 3          | Product 3  | 30    |
| 2          | Product 2  | 20    |
| 1          | Product 1  | 10    |

Solution

SELECT TOP 10 * FROM products ORDER BY sales DESC;

/*

The solution above is optimal because it uses the TOP keyword to limit the number of rows returned, and the ORDER BY clause to sort the rows by sales in descending order.

*/