Find the number of members living in each address Show bar chart, and I want to show x-axis from low to high order.
CREATE TABLE member (
    Member_ID int,
    Name text,
    Membership_card text,
    Age int,
    Time_of_purchase int,
    Level_of_membership int,
    Address text
)

CREATE TABLE happy_hour_member (
    HH_ID int,
    Member_ID int,
    Total_amount real
)

CREATE TABLE happy_hour (
    HH_ID int,
    Shop_ID int,
    Month text,
    Num_of_shaff_in_charge int
)

CREATE TABLE shop (
    Shop_ID int,
    Address text,
    Num_of_staff text,
    Score real,
    Open_Year text
)
SELECT Address, COUNT(*) FROM member GROUP BY Address ORDER BY Address
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: Find the number of members living in each address Show bar chart, and I want to show x-axis from low to high order. ### Input: CREATE TABLE member (
    Member_ID int,
    Name text,
    Membership_card text,
    Age int,
    Time_of_purchase int,
    Level_of_membership int,
    Address text
)

CREATE TABLE happy_hour_member (
    HH_ID int,
    Member_ID int,
    Total_amount real
)

CREATE TABLE happy_hour (
    HH_ID int,
    Shop_ID int,
    Month text,
    Num_of_shaff_in_charge int
)

CREATE TABLE shop (
    Shop_ID int,
    Address text,
    Num_of_staff text,
    Score real,
    Open_Year text
) ### Response: SELECT Address, COUNT(*) FROM member GROUP BY Address ORDER BY Address