CREATE TABLE happy_hour (HH_ID NUMBER, Shop_ID NUMBER, Month CLOB, Num_of_shaff_in_charge NUMBER)
CREATE TABLE member (Member_ID NUMBER, Name CLOB, Membership_card CLOB, Age NUMBER, Time_of_purchase NUMBER, Level_of_membership NUMBER, Address CLOB)
CREATE TABLE happy_hour_member (HH_ID NUMBER, Member_ID NUMBER, Total_amount FLOAT)
CREATE TABLE shop (Shop_ID NUMBER, Address CLOB, Num_of_staff CLOB, Score FLOAT, Open_Year CLOB)

Find the number of members living in each address Show bar chart, I want to show by the total number in asc.
SELECT Address, COUNT(*) FROM member GROUP BY Address ORDER BY COUNT(*)
SELECT "Address", COUNT(*) FROM "member" GROUP BY "Address" ORDER BY COUNT(*)