Who are all the party hosts?
select * from party_host
What are their names?
select t2.name from party_host as t1 join host as t2 on t1.host_id = t2.host_id
Show the themes of parties they host along with their name.
select t3.party_theme, 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