SELECT Hometown, COUNT(Hometown) FROM member GROUP BY Hometown ORDER BY COUNT(Hometown)
Count the hometown by hometown, could you display how many hometown in ascending order?
CREATE TABLE branch (
    Branch_ID int,
    Name text,
    Open_year text,
    Address_road text,
    City text,
    membership_amount text
)

CREATE TABLE membership_register_branch (
    Member_ID int,
    Branch_ID text,
    Register_Year text
)

CREATE TABLE member (
    Member_ID int,
    Card_Number text,
    Name text,
    Hometown text,
    Level int
)

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