Can you find the name of the most expensive hardware product please?
select product_name from products where product_type_code = 'Hardware' order by product_price desc limit 1
What is its product price?
select product_price from products where product_type_code = 'Hardware' order by product_price desc limit 1
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
What is the average price of all hardware products?
select avg ( product_price ) from products where product_type_code = 'Hardware'
What is the average price of all clothes products?
select avg ( product_price ) from products where product_type_code = 'Clothes'