Show all cities without a branch having more than 100 memberships.
CREATE TABLE branch (city VARCHAR, membership_amount INTEGER)
SELECT city FROM branch EXCEPT SELECT city FROM branch WHERE membership_amount > 100
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE branch (city VARCHAR, membership_amount INTEGER) Question: Show all cities without a branch having more than 100 memberships. [/INST] SELECT city FROM branch EXCEPT SELECT city FROM branch WHERE membership_amount > 100 </s>