Write a SQL query to find the names of the two highest scoring individuals in a table of data.
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.
id | name | score
1 | John | 10
2 | Jane | 9
3 | Joe | 8
4 | Jill | 7
ORDER BY score DESC
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.
The candidate's solution is correct and demonstrates a good understanding of SQL.
Evaluated at: 2022-11-08 00:15:45