Count the hometown by hometown, I want to sort by the X-axis in asc.
CREATE TABLE membership_register_branch (
    Member_ID int,
    Branch_ID text,
    Register_Year text
)

CREATE TABLE branch (
    Branch_ID int,
    Name text,
    Open_year text,
    Address_road text,
    City text,
    membership_amount text
)

CREATE TABLE purchase (
    Member_ID int,
    Branch_ID text,
    Year text,
    Total_pounds real
)

CREATE TABLE member (
    Member_ID int,
    Card_Number text,
    Name text,
    Hometown text,
    Level int
)
SELECT Hometown, COUNT(Hometown) FROM member GROUP BY Hometown ORDER BY Hometown
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: Count the hometown by hometown, I want to sort by the X-axis in asc. ### Input: CREATE TABLE membership_register_branch (
    Member_ID int,
    Branch_ID text,
    Register_Year text
)

CREATE TABLE branch (
    Branch_ID int,
    Name text,
    Open_year text,
    Address_road text,
    City text,
    membership_amount text
)

CREATE TABLE purchase (
    Member_ID int,
    Branch_ID text,
    Year text,
    Total_pounds real
)

CREATE TABLE member (
    Member_ID int,
    Card_Number text,
    Name text,
    Hometown text,
    Level int
) ### Response: SELECT Hometown, COUNT(Hometown) FROM member GROUP BY Hometown ORDER BY Hometown