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

Show the number of purchases for each coffee shop address in a pie chart.
SELECT Address, COUNT(Address) FROM member GROUP BY Address ORDER BY Time_of_purchase
SELECT "Address", COUNT("Address") FROM "member" GROUP BY "Address" ORDER BY "Time_of_purchase" NULLS FIRST