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)

Show all party names and the number of members in each party with a bar chart, and rank in desc by the y-axis.
SELECT Party_name, COUNT(*) FROM member AS T1 JOIN party AS T2 ON T1.Party_ID = T2.Party_ID GROUP BY T1.Party_ID ORDER BY COUNT(*) DESC
SELECT "Party_name", COUNT(*) FROM "member" "T1" JOIN "party" "T2" ON "T1"."Party_ID" = "T2"."Party_ID" GROUP BY "T1"."Party_ID" ORDER BY COUNT(*) DESC