Database: department_store
Question: What are the maximum and minimum product prices for each product type?
SQL:
SELECT product_type_code ,  max(product_price) ,  min(product_price) FROM products GROUP BY product_type_code