What are all the products?
select * from products
What about those with price higher than average?
select * from products where product_price > (select avg(product_price) from products)
Show their distinct names.
select distinct product_name from products where product_price > (select avg(product_price) from products)