Find names of people with score > 80

Problem

Given a table of data with the following columns:
id
name
score
Write a SQL query that returns the names of all the people who have a score greater than 80.
Input:
id | name | score
1 | John | 90
2 | Jane | 89
3 | Joe | 70
4 | Jill | 95
Output:
John
Jane
Jill

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 who have a score greater than 80.

*/