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