What is the product name and price for the least expensive hardware product?
SELECT product_name,product_price FROM products WHERE product_type_code   =   'Hardware' ORDER BY product_price asc LIMIT 1
least expensive refers to MIN(product_price); product name and price refers to product_name, product_price; hardware product refers to product_type_code = 'Hardware';