human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
find the names of manufactures that are based in Tokyo.
assistant
SELECT name FROM manufacturers WHERE headquarter = 'Tokyo';
human
how about in Beijing?
assistant
SELECT name FROM manufacturers WHERE headquarter = 'Beijing';
human
what is the total number of companies based in these two places?
assistant
SELECT COUNT( * ) FROM manufacturers WHERE headquarter = "Tokyo" OR headquarter = "Beijing" ;