SCHEMA:
CREATE TABLE products (product_category_code VARCHAR, product_price INTEGER)
USER:
What is the average price of the products for each category?

QUERY:
SELECT AVG(product_price), product_category_code FROM products GROUP BY product_category_code