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
which locations of parties have hosts older than 50?
assistant
SELECT T3.Location FROM party_host AS T1 JOIN HOST AS T2 ON T1.Host_ID = T2.Host_ID JOIN party AS T3 ON T1.Party_ID = T3.Party_ID WHERE T2.Age > 50;
human
How many hosts does party theme spring have?
assistant
SELECT number_of_hosts FROM party WHERE party_theme = 'Spring';
human
How many parties are hosted in Hemkade 48 Zaandam?
assistant
SELECT COUNT( * ) FROM party WHERE location = 'Hemkade 48 Zaandam';
human
How many hosts have the nationality united states?
assistant
SELECT COUNT( * ) FROM host WHERE nationality = "United States" ;