CREATE TABLE shop (Shop_ID NUMBER, Address CLOB, Num_of_staff CLOB, Score FLOAT, Open_Year CLOB)
CREATE TABLE happy_hour_member (HH_ID NUMBER, Member_ID NUMBER, Total_amount FLOAT)
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 (HH_ID NUMBER, Shop_ID NUMBER, Month CLOB, Num_of_shaff_in_charge NUMBER)

Show the average age of members for each coffee shop address in a bar chart.
SELECT Address, AVG(Age) FROM member GROUP BY Address ORDER BY Time_of_purchase
SELECT "Address", AVG("Age") FROM "member" GROUP BY "Address" ORDER BY "Time_of_purchase"