human
Schema:
company (Company_ID, Rank, Company, Headquarters, Main_Industry, Sales_billion, Profits_billion, Assets_billion, Market_Value)
gas_station (Station_ID, Open_Year, Location, Manager_Name, Vice_Manager_Name, Representative_Name)
station_company (Station_ID, Company_ID, Rank_of_the_Year)
Please answer with SQL.
assistant
Sure, I understand.
human
What is the profits billion of Company ExonMobil?
assistant
SELECT Profits_billion FROM company WHERE company = 'ExxonMobil';
human
What is the name of the company which has market value 213.7?
assistant
SELECT Company FROM company WHERE Market_Value = 213.7;
human
Where is the headquarters of the company general electric?
assistant
SELECT Headquarters FROM company WHERE Company = "General Electric" ;