Database: department_store
Question: Find the product type whose average price is higher than the average price of all products.
SQL:
SELECT product_type_code FROM products GROUP BY product_type_code HAVING avg(product_price)  >  (SELECT avg(product_price) FROM products)