Problem

Given a table of products with the following schema:
CREATE TABLE products (
id INTEGER,
name TEXT,
price INTEGER
);
Write a SQL query to find the cheapest product.
Example input:
id | name | price
1 | Product A | 10
2 | Product B | 20
3 | Product C | 30
Example output:
id | name | price
1 | Product A | 10

Solution

SELECT * FROM products ORDER BY price ASC LIMIT 1;

/*

The above query is optimal because it uses the ORDER BY clause to sort the products by price in ascending order, and then uses the LIMIT clause to return the first row.

*/