CREATE TABLE branch (Branch_ID NUMBER, Name CLOB, Open_year CLOB, Address_road CLOB, City CLOB, membership_amount CLOB)
CREATE TABLE membership_register_branch (Member_ID NUMBER, Branch_ID CLOB, Register_Year CLOB)
CREATE TABLE member (Member_ID NUMBER, Card_Number CLOB, Name CLOB, Hometown CLOB, Level NUMBER)
CREATE TABLE purchase (Member_ID NUMBER, Branch_ID CLOB, Year CLOB, Total_pounds FLOAT)

Compare the number of cities from the branch table.
SELECT City, COUNT(City) FROM branch GROUP BY City ORDER BY Open_year
SELECT "City", COUNT("City") FROM "branch" GROUP BY "City" ORDER BY "Open_year"