Problem

Given a table of data with three columns - id, name, and score - write a SQL query to find the names of the two highest scoring individuals.
Example input:
id | name | score
1 | John | 10
2 | Jane | 9
3 | Joe | 8
4 | Jill | 7
Example output:
name
John
Jane

Solution

SELECT name
FROM table
ORDER BY score DESC
LIMIT 2;

/*

This solution is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by score in descending order and then limit the results to the first two rows.

*/