SELECT city FROM branch EXCEPT SELECT city FROM branch WHERE membership_amount  >  100
Show all cities without a branch having more than 100 memberships.
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 > value
Show all cities without a branch having more than 100 memberships .