What is the average price for each type of product?
CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER)
SELECT product_type_code, AVG(product_price) FROM products GROUP BY product_type_code
### Context: CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER) ### Question: What is the average price for each type of product? ### Answer: SELECT product_type_code, AVG(product_price) FROM products GROUP BY product_type_code