Database: cre_Drama_Workshop_Groups
Question: Show all the distinct product names with price higher than the average.
SQL:
SELECT DISTINCT Product_Name FROM PRODUCTS WHERE Product_Price  >  (SELECT avg(Product_Price) FROM PRODUCTS)