Database: customers_and_orders
Question: Show all hardware product names with price higher than the average price of hardware type 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")