Problem

Given a table of customer data, write a SQL query to find the top 3 customers with the highest average order value.
Example input:
Customer_ID  |  Order_Value
1             |  100
2             |  200
3             |  300
4             |  400
5             |  500
6             |  600
7             |  700
8             |  800
9             |  900
10            |  1000
Example output:
Customer_ID  |  Average Order Value
4             |  400
5             |  500
6             |  600

Solution

SELECT Customer_ID, AVG(Order_Value)
FROM Customer_Data
GROUP BY Customer_ID
ORDER BY AVG(Order_Value) DESC
LIMIT 3;

/*

This solution is optimal because it uses the GROUP BY and ORDER BY clauses to group the data by customer ID and then order the data by the average order value.
The LIMIT clause is used to limit the results to the top 3 customers.

*/