which locations of parties have hosts older than 50?
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
How many hosts does party theme spring have?
select number_of_hosts from party where party_theme = "Spring"
How many parties are hosted in Hemkade 48 Zaandam?
select count ( * ) from party where location = "Hemkade 48 Zaandam"
How many hosts have the nationality united states?
select count ( * ) from host where nationality = "United States"