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 locations of parties they host along with their names.
select t3.location, 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
Order them by the age of the host.
select t3.location, 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 order by t2.age