human
Schema:
region (Region_ID, Region_name, Date, Label, Format, Catalogue)
party (Party_ID, Minister, Took_office, Left_office, Region_ID, Party_name)
member (Member_ID, Member_Name, Party_ID, In_office)
party_events (Event_ID, Event_Name, Party_ID, Member_in_charge_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the names of parties with 2 events
assistant
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;
human
what is the minister name of the party with 2 events
assistant
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;
human
what are the minister names of the parties with 1 events
assistant
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;
human
what is the name of the party with region ID 3
assistant
SELECT party_name FROM party WHERE Region_id = 3 ;