Database: customers_and_orders
Question: Show all product type codes and the average price for each type.
SQL:
SELECT product_type_code ,  avg(product_price) FROM Products GROUP BY product_type_code