How many members are in each party Show bar chart, and rank by the the total number in asc.
CREATE TABLE party_events (
    Event_ID int,
    Event_Name text,
    Party_ID int,
    Member_in_charge_ID int
)

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 region (
    Region_ID int,
    Region_name text,
    Date text,
    Label text,
    Format text,
    Catalogue text
)
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(*)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many members are in each party Show bar chart, and rank by the the total number in asc. ### Input: CREATE TABLE party_events (
    Event_ID int,
    Event_Name text,
    Party_ID int,
    Member_in_charge_ID int
)

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 region (
    Region_ID int,
    Region_name text,
    Date text,
    Label text,
    Format text,
    Catalogue text
) ### Response: 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(*)