Database: department_store
Question: Return the average price for each product type.
SQL:
SELECT product_type_code ,  avg(product_price) FROM products GROUP BY product_type_code