human
Schema:
Manufacturers (Code, Name, Headquarter, Founder, Revenue)
Products (Code, Name, Price, Manufacturer)
Please answer with SQL.
assistant
Sure, I understand.
human
How many companies are there?
assistant
SELECT COUNT( * ) FROM Manufacturers;
human
What are their founder names?
assistant
SELECT Name FROM Manufacturers;
human
Show founder names that begin with letter 'S' | Did you mean founder s name that begin with letter 'S'? | yes
assistant
SELECT founder FROM manufacturers WHERE Founder LIKE 'S%';
human
Ok, than show all companies headquarters
assistant
SELECT Headquarter FROM manufacturers ;