May I have their product names please?
SELECT distinct product_name FROM products WHERE product_price <  ( SELECT avg ( product_price )  FROM products ) 
product names with a price less than the average price of all products;