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
what is the highest profits of companies
assistant
SELECT MAX( Profits_billion ) FROM Companies;
human
what is the market value of JPMorgan Chase
assistant
SELECT Market_Value_billion FROM Companies WHERE name = 'JPMorgan Chase';
human
what is name of headquarters on General Electric
assistant
SELECT Headquarters FROM Companies WHERE name = "General Electric" ;