Database: customers_and_orders
Question: Show all product names with price higher than the average.
SQL:
SELECT product_name FROM Products WHERE product_price  >  (SELECT avg(product_price) FROM Products)