Hello!  Can you provide me with a list of all the different product types?
select distinct product_type_code from products group by product_type_code
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
Cool!  Can you show me a list of all of the different product names?
select distinct product_name from products