SELECT product_type_code ,  max(product_price) ,  min(product_price) FROM products GROUP BY product_type_code
For each product type, return the maximum and minimum price.
SELECT product_type_code , max ( product_price ) , min ( product_price ) FROM products GROUP BY product_type_code
select product_type_code , max ( product_price ) , min ( product_price ) from products group by product_type_code
For each product type , return the maximum and minimum price .