human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
what are the names of the companies based in Austin?
assistant
SELECT name FROM manufacturers WHERE headquarter = 'Austin';
human
find the names of companies whose revenue is larger than the largest revenue of those companies.
assistant
SELECT name FROM manufacturers WHERE revenue > ( SELECT MIN( revenue ) FROM manufacturers WHERE headquarter = "Austin" ) ;