Database: customers_and_orders
Question: What are the names of products that have a price above the average for all products.
SQL:
SELECT product_name FROM Products WHERE product_price  >  (SELECT avg(product_price) FROM Products)