Who are all the party hosts?
select * from party_host
Show the name of those who are order than 50.
select t2.name from party_host as t1 join host as t2 on t1.host_id = t2.host_id where t2.age > 50
What about the locations of parties they host?
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