human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
Who the founder of Sony? | Did you mean the founder of the manufacturer named Sony? | Yes
assistant
SELECT founder FROM manufacturers WHERE name = 'Sony';
human
Which company is headed by Austin city? | Did you mean the name of manufacturers whose headquarters are Austin? | Yes
assistant
SELECT name FROM manufacturers WHERE headquarter = 'Austin';
human
What are the revenue of manufacture name Hewlett-Packard?
assistant
SELECT revenue FROM manufacturers WHERE name = 'Hewlett-Packard';
human
Find the number of manufactures that are based in Tokyo or Beijing.
assistant
SELECT COUNT( * ) FROM manufacturers WHERE headquarter = "Tokyo" OR headquarter = "Beijing" ;