CREATE TABLE member (Member_ID NUMBER, Card_Number CLOB, Name CLOB, Hometown CLOB, Level NUMBER)
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 membership_register_branch (Member_ID NUMBER, Branch_ID CLOB, Register_Year CLOB)

Bar chart of the number of hometown from each hometown, and I want to display total number in descending order.
SELECT Hometown, COUNT(Hometown) FROM member GROUP BY Hometown ORDER BY COUNT(Hometown) DESC
SELECT "Hometown", COUNT("Hometown") FROM "member" GROUP BY "Hometown" ORDER BY COUNT("Hometown") DESC