Problem

Given a database table with the following schema:
CREATE TABLE products (
id INTEGER PRIMARY KEY,
name TEXT,
price INTEGER
);
Write a SQL query to find the products that have a price greater than the average price of all products.
Example input:
id | name | price
1 | product1 | 10
2 | product2 | 20
3 | product3 | 30
4 | product4 | 40
5 | product5 | 50
Example output:
id | name | price
3 | product3 | 30
4 | product4 | 40
5 | product5 | 50

Solution

SELECT * FROM products WHERE price > (SELECT AVG(price) FROM products);

/*

The above solution is optimal because it only requires one query to the database.

*/