what is the name of the most expensive hardware product?
select product_name from products where product_type_code = 'Hardware' order by product_price desc limit 1
what is the product price?
select product_price from products where product_type_code = 'Hardware' order by product_price desc limit 1
what is the product id  for red jeans?
select product_id from products where product_name = "red jeans"
what is the product type code for red jeans
select distinct ( product_type_code ) from products where product_name = "red jeans"