What is the average price of the products for each category?
CREATE TABLE products (product_category_code VARCHAR, product_price INTEGER)
[SQL] SELECT AVG(product_price), product_category_code FROM products GROUP BY product_category_code [/SQL]