CREATE TABLE products (code VARCHAR2, name VARCHAR2, price NUMBER)

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"