CREATE TABLE membership_register_branch (Member_ID NUMBER, Branch_ID CLOB, Register_Year CLOB)
CREATE TABLE branch (Branch_ID NUMBER, Name CLOB, Open_year CLOB, Address_road CLOB, City CLOB, membership_amount CLOB)
CREATE TABLE purchase (Member_ID NUMBER, Branch_ID CLOB, Year CLOB, Total_pounds FLOAT)
CREATE TABLE member (Member_ID NUMBER, Card_Number CLOB, Name CLOB, Hometown CLOB, Level NUMBER)

Count the hometown by hometown, I want to sort by the X-axis in asc.
SELECT Hometown, COUNT(Hometown) FROM member GROUP BY Hometown ORDER BY Hometown
SELECT "Hometown", COUNT("Hometown") FROM "member" GROUP BY "Hometown" ORDER BY "Hometown"