human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
Can you list all companies based in Austin and their revenues?
assistant
SELECT Name , Revenue FROM Manufacturers WHERE Headquarter = 'Austin';
human
Can you list all companies whose revenue is less than 100?
assistant
SELECT Name FROM Manufacturers WHERE Revenue < 100 ;