What are the average prices of products, grouped by manufacturer code?
select avg(price), manufacturer from products group by manufacturer