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 NUMBER)
CREATE TABLE branch (branch_id NUMBER, name CLOB, open_year CLOB, address_road CLOB, city CLOB, membership_amount CLOB)
CREATE TABLE member (member_id NUMBER, card_number CLOB, name CLOB, hometown CLOB, level NUMBER)

What are the cities that have a branch that opened in 2001 and a branch with more than 100 members?
SELECT city FROM branch WHERE open_year = 2001 AND membership_amount > 100
SELECT "city" FROM "branch" WHERE "membership_amount" > 100 AND "open_year" = 2001