Can you list the product names of all products with prices below the average product price?
select product_name from products where product_price < ( SELECT avg ( product_price )  from products ) 
products with prices below the average product price refers to product_price < AVG(product_price); list product names refers to SELECT product_name;