Find the product type whose average price is higher than the average price of all products.
CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER)
SELECT product_type_code FROM products GROUP BY product_type_code HAVING AVG(product_price) > (SELECT AVG(product_price) FROM products)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER) Question: Find the product type whose average price is higher than the average price of all products. [/INST] SELECT product_type_code FROM products GROUP BY product_type_code HAVING AVG(product_price) > (SELECT AVG(product_price) FROM products) </s>