Database: customers_and_orders
Question: What is the product id and product name for the cheapest Hardware type product?
SQL:
SELECT product_id ,  product_name FROM Products WHERE product_type_code  =  "Hardware" ORDER BY product_price ASC LIMIT 1