Database: department_store
Question: Give the maximum and minimum product prices for each product type, grouped and ordered by product type.
SQL:
SELECT max(product_price) ,  min(product_price) ,  product_type_code FROM products GROUP BY product_type_code ORDER BY product_type_code