Problem

Given a table of customer information, write a SQL query to find the customer with the highest balance.
Example input:
| customer_id | name       | balance |
|--------------|------------|---------|
| 1            | John Smith | 100.00  |
| 2            | Jane Doe   | 200.00  |
| 3            | Joe Shmoe  | 300.00  |
Example output:
| customer_id | name       | balance |
|--------------|------------|---------|
| 3            | Joe Shmoe  | 300.00  |

Solution

SELECT customer_id, name, balance
FROM customers
ORDER BY balance DESC
LIMIT 1;

/*

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

*/