SCHEMA:
CREATE TABLE products (product_price INTEGER)
USER:
How many products have a price higher than the average?

QUERY:
SELECT COUNT(*) FROM products WHERE product_price > (SELECT AVG(product_price) FROM products)