Find all products that cost more than $10

Write a SQL query to find all products in a table that cost more than $10.

Problem

Given a table of products with columns for id, name, and price, write a SQL query to find all products that cost more than $10.
Example input:
id | name | price
1 | product1 | 12
2 | product2 | 9
3 | product3 | 15
4 | product4 | 8
Example output:
id | name | price
1 | product1 | 12
3 | product3 | 15

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.
by sarastevens 
SELECT * FROM products WHERE price > 10;

/*

The above solution is optimal because it uses the WHERE clause to filter the results.

*/
A.I. Evaluation of the Solution

The candidate's solution is correct and demonstrates a good understanding of SQL. The solution is also efficient, as it uses the WHERE clause to filter the results.

Evaluated at: 2022-11-10 00:15:56