SELECT DISTINCT Product_Name FROM PRODUCTS WHERE Product_Price  >  (SELECT avg(Product_Price) FROM PRODUCTS)
What are the distinct names of the products that cost more than the average?
SELECT DISTINCT Product_Name FROM PRODUCTS WHERE Product_Price > ( SELECT avg ( Product_Price ) FROM PRODUCTS )
select distinct product_name from products where product_price > ( select avg ( product_price ) from products )
What are the distinct names of the products that cost more than the average ?