Problem

Given a table of customer data, write a SQL query to find the top 10 customers by total spent.
Input: 
customer_id | name | total_spent
1 | John | 100
2 | Jane | 500
3 | Joe | 300
4 | Jill | 200
5 | Bob | 400
Output: 
customer_id | name | total_spent
2 | Jane | 500
5 | Bob | 400
3 | Joe | 300
4 | Jill | 200

Solution

SELECT customer_id, name, total_spent
FROM customers
ORDER BY total_spent DESC
LIMIT 10;

/*

The solution above is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by total_spent in descending order and then limit the results to the top 10 customers.

*/