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 NUMBER)

Show the city and the number of branches opened before 2010 for each city.
SELECT city, COUNT(*) FROM branch WHERE open_year < 2010 GROUP BY city
SELECT "city", COUNT(*) FROM "branch" WHERE "open_year" < 2010 GROUP BY "city"