Select the code of the product that is cheapest in each product category.
CREATE TABLE products (code VARCHAR, name VARCHAR, price INTEGER)
[SQL] SELECT code, name, MIN(price) FROM products GROUP BY name [/SQL]