SELECT product_type_code ,  avg(product_price) FROM products GROUP BY product_type_code
Return the average price for each product type.
SELECT product_type_code , avg ( product_price ) FROM products GROUP BY product_type_code
select product_type_code , avg ( product_price ) from products group by product_type_code
Return the average price for each product type .