human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the total revenue for each manufacturer.
assistant
SELECT sum(revenue) , name FROM manufacturers GROUP BY name
human
Select the average price of each manufacturer's products, showing the manufacturer's name.
assistant
SELECT avg(T1.Price) , T2.name FROM products AS T1 JOIN Manufacturers AS T2 ON T1.manufacturer = T2.code GROUP BY T2.name
human
Select the average price of each manufacturer's products, showing only the manufacturer's code.
assistant
SELECT AVG(Price) , Manufacturer FROM Products GROUP BY Manufacturer
human
Find the average prices of all products from each manufacture, and list each company's name.
assistant
SELECT avg(T1.price) , T2.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code GROUP BY T2.name
human
Compute the average price of all the products.
assistant
SELECT avg(price) FROM products
human
Compute the average price of all products with manufacturer code equal to 2.
assistant
SELECT avg ( price ) FROM products WHERE Manufacturer = 2 ;