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
Hello! Can you show me a list of all company IDs, with their names and headquarters locations?
assistant
SELECT Company_ID , Name , Headquarters FROM company;
human
Could you filter this same list to list only the Headquarter countries that have more than one company in them?
assistant
SELECT Headquarters FROM company GROUP BY Headquarters HAVING COUNT( * ) > = 2 ;