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
Which company has the largest sales? | Did you mean the name of the company with the largest sales? | Yes thr name of the company that has the largest sales
assistant
SELECT name FROM company ORDER BY Sales_in_Billion DESC LIMIT 1;
human
Where is the headquarters of royal dutch shell?
assistant
SELECT headquarters FROM company WHERE name = 'Royal Dutch Shell';
human
What kind of industry does royal dutch shell belongs to?
assistant
SELECT Industry FROM company WHERE name = "Royal Dutch Shell" ;