What is the average price for prodcuts?
select avg(product_price) from products
Show product information for products more expensive than the average.
select * from products where product_price > (select avg(product_price) from products)
How many such products are there?
select count(*) from products where product_price > (select avg(product_price) from products)