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;

/*

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

*/