CREATE TABLE products (code VARCHAR, name VARCHAR, price INT)

Select the code of the product that is cheapest in each product category.
SELECT code, name, MIN(price) FROM products GROUP BY name
SELECT "code", "name", MIN("price") FROM "products" GROUP BY "name"