SELECT product_name FROM products WHERE product_type_code  =  'Hardware' ORDER BY product_price DESC LIMIT 1
What is the name of the hardware product with the greatest price?
SELECT product_name FROM products WHERE product_type_code = 'Hardware ' ORDER BY product_price DESC LIMIT 1
select product_name from products where product_type_code = value order by product_price desc limit value
What is the name of the hardware product with the greatest price ?