Problem

Given a table of customer data, write a SQL query to find the top 10 customers by total spend.
Example input:
customers
id name total_spend
1 John Doe $100
2 Jane Smith $200
3 Bob Jones $300
Example output:
id name total_spend
3 Bob Jones $300
2 Jane Smith $200
1 John Doe $100

Solution

SELECT id, name, total_spend
FROM customers
ORDER BY total_spend DESC
LIMIT 10;

/*

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

*/