How many products have a price higher than the average?
CREATE TABLE products (product_price INTEGER)
SELECT COUNT(*) FROM products WHERE product_price > (SELECT AVG(product_price) FROM products)
### Context: CREATE TABLE products (product_price INTEGER) ### Question: How many products have a price higher than the average? ### Answer: SELECT COUNT(*) FROM products WHERE product_price > (SELECT AVG(product_price) FROM products)