SELECT avg(product_price) ,  product_category_code FROM products GROUP BY product_category_code
What is the average price of the products for each category?
SELECT avg ( product_price ) , product_category_code FROM products GROUP BY product_category_code
select avg ( product_price ) , product_category_code from products group by product_category_code
What is the average price of the products for each category ?