SQL query to return names of people with score > 80

Problem

Given a table of data with the following columns:
id (integer)
name (string)
score (integer)
Write a SQL query that returns the names of all the people with a score greater than 80.
Example input:
id | name | score
----|------|------
1  | John | 90
2  | Jane | 60
3  | Joe  | 85
4  | Jill | 75
Example output:
name
----
John
Joe

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

SELECT name
FROM table
WHERE score > 80;

/*

The above solution is optimal because it is the most efficient way to get the names of all the people with a score greater than 80.

*/