Select the average price of each manufacturer's products, showing only the manufacturer's code.
select avg(price), manufacturer from products group by manufacturer