How many products have a price higher than the average?
CREATE TABLE products (product_price INTEGER)
[SQL] SELECT COUNT(*) FROM products WHERE product_price > (SELECT AVG(product_price) FROM products) [/SQL]