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)
CREATE TABLE member (Member_ID NUMBER, Member_Name CLOB, Party_ID CLOB, In_office CLOB)
CREATE TABLE party_events (Event_ID NUMBER, Event_Name CLOB, Party_ID NUMBER, Member_in_charge_ID NUMBER)

Bar chart x axis minister y axis how many minister, list names from low to high order.
SELECT Minister, COUNT(Minister) FROM party GROUP BY Minister ORDER BY Minister
SELECT "Minister", COUNT("Minister") FROM "party" GROUP BY "Minister" ORDER BY "Minister"