human
Schema:
party (Party_ID, Party_Theme, Location, First_year, Last_year, Number_of_hosts)
host (Host_ID, Name, Nationality, Age)
party_host (Party_ID, Host_ID, Is_Main_in_Charge)
Please answer with SQL.
assistant
Sure, I understand.
human
What are all the parties?
assistant
SELECT * FROM party;
human
Order them by the number of hosts.
assistant
SELECT * FROM party ORDER BY Number_of_hosts;
human
Show the location of the top one.
assistant
SELECT LOCATION FROM party ORDER BY Number_of_hosts DESC LIMIT 1 ;