SELECT count(*) FROM products WHERE product_price  >  (SELECT avg(product_price) FROM products)
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 )
How many products have a price higher than the average ?