How many products have a price higher than the average?
SELECT count(*) FROM products WHERE product_price  >  (SELECT avg(product_price) FROM products)
SELECT count(*) FROM products WHERE product_price  >  (SELECT avg(product_price) FROM products)
[{'count(*)': 3}]