human
Schema:
buildings (id, name, City, Height, Stories, Status)
Companies (id, name, Headquarters, Industry, Sales_billion, Profits_billion, Assets_billion, Market_Value_billion)
Office_locations (building_id, company_id, move_in_year)
Please answer with SQL.
assistant
Sure, I understand.
human
Which company has its headquarter in the US? | Did you mean to ask for the companies with headquarters in USA? | yes.
assistant
SELECT name FROM Companies WHERE Headquarters = 'USA';
human
What is the industry of the company named General Electric?
assistant
SELECT Industry FROM Companies WHERE name = 'General Electric';
human
How much profit did it make ?
assistant
SELECT Profits_billion FROM Companies WHERE name = "General Electric" ;