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