How many products have a price higher than the average?
SELECT count ( * )  FROM products WHERE product_price  >   ( SELECT avg ( product_price )  FROM products ) 
products with price higher than the average refers to product_price > AVG(product_price); count of such products refers to COUNT(*)