Database: customers_and_orders
Question: Count the number of products of the type Hardware.
SQL:
SELECT count(*) FROM Products WHERE product_type_code  =  "Hardware"