Show all city with a branch opened in 2001 and a branch with more than 100 membership.
CREATE TABLE branch (city VARCHAR, open_year VARCHAR, membership_amount VARCHAR)
SELECT city FROM branch WHERE open_year = 2001 AND membership_amount > 100
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE branch (city VARCHAR, open_year VARCHAR, membership_amount VARCHAR) Question: Show all city with a branch opened in 2001 and a branch with more than 100 membership. [/INST] SELECT city FROM branch WHERE open_year = 2001 AND membership_amount > 100 </s>