human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
where is the Headquarter of Sony?
assistant
SELECT Headquarter FROM manufacturers WHERE Name = 'Sony';
human
how much is Creative Labs revenue?
assistant
SELECT Revenue FROM manufacturers WHERE Name = 'Creative Labs';
human
what is the name of the manufacturer whose headquarter is in Los Angeles?
assistant
SELECT name FROM manufacturers WHERE Headquarter = "Los Angeles" ;