Show all the products.
select * from products
Group all the products by product type.
select * from products group by product_type_code
What is the average price for each type of product?
select product_type_code, avg(product_price) from products group by product_type_code