What is the average price of all products?
select avg ( product_price ) from products
What are the product names that have a price higher than the average?
select product_name from products where product_price > ( select avg ( product_price ) from products )
How many products have a price higher than the average?
select count ( * ) from products where product_price > ( select avg ( product_price ) from products )