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

Show all party names and the number of members in each party Show bar chart, and order the total number in ascending order.
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(*)
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(*) NULLS FIRST