CREATE TABLE membership_register_branch (Member_ID NUMBER, Branch_ID CLOB, Register_Year CLOB)
CREATE TABLE purchase (Member_ID NUMBER, Branch_ID CLOB, Year CLOB, Total_pounds FLOAT)
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)

Compute the total how many city across city as a pie chart.
SELECT City, COUNT(City) FROM branch GROUP BY City
SELECT "City", COUNT("City") FROM "branch" GROUP BY "City"