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
Show me a list of party ministers.
assistant
SELECT minister FROM party;
human
Which ones took office between 1959 and 1961?
assistant
SELECT minister FROM party WHERE took_office >= 1959 AND took_office <= 1961;
human
How about the others except those?
assistant
SELECT minister FROM party WHERE took_office > 1961 OR took_office < 1959 ;