What are all the product types?
select product_type_code from products
What is the average price of products?
select avg(product_price) from products
Find the product type whose average price is higher than the average price of all products.
select product_type_code from products group by product_type_code having avg(product_price) > (select avg(product_price) from products)