What is the average price of all products?
select avg(product_price) from products
Which of the procucts cost more than this?
select * from products where product_price > (select avg(product_price) from products)
Which is the name of the most expensive product?
select product_name from products order by product_price desc limit 1