SELECT DISTINCT Product_Name FROM PRODUCTS WHERE Product_Price  >  (SELECT avg(Product_Price) FROM PRODUCTS)
Show all the distinct product names with price higher 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 )
Show all the distinct product names with price higher than the average .