Select the average price of each manufacturer's products, showing only the manufacturer's code.
CREATE TABLE Products (Manufacturer VARCHAR, Price INTEGER)
SELECT AVG(Price), Manufacturer FROM Products GROUP BY Manufacturer
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Products (Manufacturer VARCHAR, Price INTEGER) Question: Select the average price of each manufacturer's products, showing only the manufacturer's code. [/INST] SELECT AVG(Price), Manufacturer FROM Products GROUP BY Manufacturer </s>