Select the average price of each manufacturer's products, showing only the manufacturer's code.
CREATE TABLE Products (Manufacturer VARCHAR, Price INTEGER)
[SQL] SELECT AVG(Price), Manufacturer FROM Products GROUP BY Manufacturer [/SQL]