Select the code of the product that is cheapest in each product category.
CREATE TABLE products (code VARCHAR, name VARCHAR, price INTEGER)
SELECT code, name, MIN(price) FROM products GROUP BY name
### Context: CREATE TABLE products (code VARCHAR, name VARCHAR, price INTEGER) ### Question: Select the code of the product that is cheapest in each product category. ### Answer: SELECT code, name, MIN(price) FROM products GROUP BY name