Can you give me the product names for these?
SELECT product_name FROM products WHERE product_price  >   ( SELECT avg ( product_price )  FROM products ) 
product names for those with a price greater than the average product price refers to product_name WHERE product_price > (SELECT AVG(product_price) FROM products);