What are the names of parties with 2 events
select t2.party_name from party_events as t1 join party as t2 on t1.party_id = t2.party_id group by t1.party_id having count ( * ) = 2
what is the minister name of the party with 2 events
select t2.minister from party_events as t1 join party as t2 on t1.party_id = t2.party_id group by t1.party_id having count ( * ) = 2
what are the minister names of the parties with 1 events
select t2.minister from party_events as t1 join party as t2 on t1.party_id = t2.party_id group by t1.party_id having count ( * ) = 1
what is the name of the party with region ID 3
select party_name from party where region_id = 3