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
How many different countries serve as headquarters?
assistant
SELECT COUNT( distinct Headquarters ) FROM company;
human
What is the most popular industry?
assistant
SELECT Industry FROM company GROUP BY Industry ORDER BY COUNT( * ) DESC LIMIT 1 ;