Sweet!  Can you update this list to show what the maximum product price is for both Clothes and Hardware, and include the minimum product price for each?
SELECT product_type_code ,  max ( product_price )  ,  min ( product_price )  FROM products GROUP BY product_type_code
maximum product price refers to MAX(product_price); minimum product price refers to MIN(product_price); for both Clothes and Hardware refers to filtering or grouping by product_type_code;