CREATE TABLE shop (Shop_ID NUMBER, Address CLOB, Num_of_staff CLOB, Score FLOAT, Open_Year CLOB)
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)

A bar chart showing the average purchase time for each coffee shop address.
SELECT Address, AVG(Time_of_purchase) FROM member GROUP BY Address ORDER BY Time_of_purchase
SELECT "Address", AVG("Time_of_purchase") FROM "member" GROUP BY "Address" ORDER BY "Time_of_purchase"