human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
What manufacturer has the highest revenue?
assistant
SELECT Name FROM manufacturers ORDER by revenue desc LIMIT 1;
human
Where is Iomega located?
assistant
SELECT Headquarter FROM manufacturers WHERE name = 'Iomega';
human
What manufacturers on the list are located in Austin?
assistant
SELECT Name FROM manufacturers WHERE Headquarter = 'Austin';
human
What is Creative labs revenue?
assistant
SELECT Revenue FROM manufacturers WHERE Name = 'Creative Labs';
human
How many companies have a revenue greater than 100.0?
assistant
SELECT COUNT( * ) FROM manufacturers WHERE revenue > 100.0;
human
What is the total revue of those 3 companies?
assistant
SELECT SUM( revenue ) FROM manufacturers WHERE revenue > 100.0 ;