CREATE TABLE membership_register_branch (member_id NUMBER, branch_id CLOB, register_year CLOB)
CREATE TABLE branch (branch_id NUMBER, name CLOB, open_year CLOB, address_road CLOB, city CLOB, membership_amount CLOB)
CREATE TABLE purchase (member_id NUMBER, branch_id CLOB, year CLOB, total_pounds NUMBER)
CREATE TABLE member (member_id NUMBER, card_number CLOB, name CLOB, hometown CLOB, level NUMBER)

What are the cities that do not have any branches with more than 100 members?
SELECT city FROM branch EXCEPT SELECT city FROM branch WHERE membership_amount > 100
SELECT "city" FROM "branch" EXCEPT SELECT "city" FROM "branch" WHERE "membership_amount" > 100