What are the names and ids of all the party events?
select event_id, event_name from party_events
What parties are each event affiliated with?
select event_id, event_name, party_id from party_events
Just show me a distinct list of the names these parties.
select distinct t2.party_name from party_events as t1 join party as t2 on t1.party_id = t2.party_id
Also show how many events each of them!
select t2.party_name, count(*) from party_events as t1 join party as t2 on t1.party_id = t2.party_id group by t1.party_id