And how many products have a price lower than the average?
SELECT count ( * )  FROM products WHERE product_price <  ( SELECT avg ( product_price )  FROM products ) 
products with a price lower than the average refers to COUNT(*) WHERE product_price < AVG(product_price);