human
Schema:
people (People_ID, Age, Name, Nationality, Graduation_College)
company (Company_ID, Name, Headquarters, Industry, Sales_in_Billion, Profits_in_Billion, Assets_in_Billion, Market_Value_in_Billion)
employment (Company_ID, People_ID, Year_working)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me the headquarters of the company HSBC.
assistant
SELECT Headquarters FROM company WHERE Name = 'HSBC';
human
What is its market value?
assistant
SELECT Market_Value_in_Billion FROM company WHERE Name = 'HSBC';
human
What is the maximum and minimum market value of companies.
assistant
SELECT MAX( Market_Value_in_Billion ) , MIN( Market_Value_in_Billion ) FROM company ;