Show all the product types.
select product_type_code from products
Order all the products by their types.
select * from products order by product_type_code
Give me the maximum and minimum price for each product type.
select product_type_code, max(product_price), min(product_price) from products group by product_type_code