SELECT code ,  name ,  min(price) FROM products GROUP BY name
What are the codes and names of the cheapest products in each category?
SELECT code , name , min ( price ) FROM products GROUP BY name
select code , name , min ( price ) from products group by name
What are the codes and names of the cheapest products in each category ?