SELECT code ,  name ,  min(price) FROM products GROUP BY name
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
Select the code of the product that is cheapest in each product category .