CREATE TABLE party_events (Event_ID NUMBER, Event_Name CLOB, Party_ID NUMBER, Member_in_charge_ID NUMBER)
CREATE TABLE region (Region_ID NUMBER, Region_name CLOB, Date CLOB, Label CLOB, Format CLOB, Catalogue CLOB)
CREATE TABLE party (Party_ID NUMBER, Minister CLOB, Took_office CLOB, Left_office CLOB, Region_ID NUMBER, Party_name CLOB)
CREATE TABLE member (Member_ID NUMBER, Member_Name CLOB, Party_ID CLOB, In_office CLOB)

How many parties of the time they took office, binning the left office into Weekday interval, and then split by the minister's name, and display in ascending by the Y-axis.
SELECT Left_office, COUNT(Left_office) FROM party GROUP BY Minister ORDER BY COUNT(Left_office)
SELECT "Left_office", COUNT("Left_office") FROM "party" GROUP BY "Minister" ORDER BY COUNT("Left_office")