SCHEMA:
CREATE TABLE products (code VARCHAR, name VARCHAR, price INTEGER)
User Question:
Select the code of the product that is cheapest in each product category.


SELECT code, name, MIN(price) FROM products GROUP BY name