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
minister name of the party with 2 events refers to SELECT Minister FROM party WHERE COUNT(events) = 2; JOIN is used to combine rows from two or more tables based on a related column between them; GROUP BY is used to arrange identical data into groups; HAVING is used to filter records that work on summarized GROUP BY results.