Problem

Given a table of data with customer information, write a SQL query to find the customer with the highest total purchase amount.
Example input:
CustomerID | Name | TotalPurchaseAmount
1 | John | 100
2 | Doe | 200
3 | Smith | 300
Example output:
3 | Smith | 300

Solution

SELECT CustomerID, Name, TotalPurchaseAmount
FROM Customer
ORDER BY TotalPurchaseAmount DESC
LIMIT 1;

/*

The above solution is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by TotalPurchaseAmount in descending order and then return the first row.

*/