Show me all parties.
select * from party
Show those with more than 20 hosts.
select * from party where number_of_hosts > 20
What are the host names for those parties?
select t2.name 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 t3.number_of_hosts > 20