Database: department_store
Question: What is the code of the product type with an average price 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)