What is the average price of all hardware products?
SELECT avg ( product_price )  FROM products WHERE product_type_code   =   'Hardware'
average price = AVG(product_price); all hardware products refers to WHERE product_type_code = 'Hardware';