human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
show the name and revenue of all companies.
assistant
SELECT name , revenue FROM manufacturers;
human
what is their average revenue?
assistant
SELECT AVG ( revenue ) FROM manufacturers ;