Database: customers_and_orders
Question: What are the names of Hardware product with prices above the average price of Hardware products.
SQL:
SELECT product_name FROM Products WHERE product_type_code  =  "Hardware" AND product_price  >  (SELECT avg(product_price) FROM Products WHERE product_type_code  =  "Hardware")