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
find the rank, company names, market values of the companies in the banking industry order by their sales and profits in billion.
assistant
SELECT rank , company , market_value FROM company WHERE main_industry = 'Banking' ORDER BY sales_billion , profits_billion;
human
Which company has the biggest market value in billion?
assistant
SELECT company FROM company ORDER BY market_value LIMIT 1;
human
what is BP's market value?
assistant
SELECT market_value FROM company WHERE Company = "BP" ;