SQL query to find names of items with price greater than or equal to $10

Problem

Given an table with the following schema:
CREATE TABLE items (
  id INTEGER PRIMARY KEY,
  name TEXT,
  price INTEGER
);
Write a SQL query to find the names of all the items that have a price greater than or equal to $10.
Example input:
| id | name      | price |
|----|-----------|-------|
| 1  | Item 1    | 15    |
| 2  | Item 2    | 10    |
| 3  | Item 3    | 5     |
Example output:
| name      |
|-----------|
| Item 1    |
| Item 2    |

Solution

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

sarastevens

SELECT name FROM items WHERE price >= 10;

/*

The solution above is optimal because it uses the WHERE clause to filter the results to only include items with a price greater than or equal to 10.

*/