show the party names and the number of events for party id 2
select t2.party_name, count ( * ) from party_events as t1 join party as t2 on t1.party_id = t2.party_id where t1.party_id = 2 group by t1.party_id
find the count of the event name took place for the party id 1
select t1.party_id, count ( t2.party_name ) from party_events as t1 join party as t2 on t1.party_id = t2.party_id where t1.party_id = 1
find the took office and region id for the event id 1
select t2.took_office,t2.region_id from party_events as t1 join party as t2 on t1.party_id = t2.party_id where t1.party_id = 1