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 is the location of the Id no-1?
assistant
SELECT Location FROM party WHERE Party_ID = 1;
human
how many host in the id no_3?
assistant
SELECT Number_of_hosts FROM party WHERE Party_ID = 3 ;