CREATE TABLE region (Region_ID NUMBER, Region_name CLOB, Date CLOB, Label CLOB, Format CLOB, Catalogue CLOB)
CREATE TABLE party_events (Event_ID NUMBER, Event_Name CLOB, Party_ID NUMBER, Member_in_charge_ID NUMBER)
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 took office into Weekday interval, and then split by the minister's name, and show y axis from high to low order.
SELECT Took_office, COUNT(Took_office) FROM party GROUP BY Minister ORDER BY COUNT(Took_office) DESC
SELECT "Took_office", COUNT("Took_office") FROM "party" GROUP BY "Minister" ORDER BY COUNT("Took_office") DESC