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

Compare the total number of each minister using a bar graph, list the number of minister in ascending order.
SELECT Minister, COUNT(Minister) FROM party GROUP BY Minister ORDER BY COUNT(Minister)
SELECT "Minister", COUNT("Minister") FROM "party" GROUP BY "Minister" ORDER BY COUNT("Minister")