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