Show all distinct city where branches with at least 100 memberships are located.
CREATE TABLE branch (city VARCHAR, membership_amount VARCHAR)
SELECT DISTINCT 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 VARCHAR) Question: Show all distinct city where branches with at least 100 memberships are located. [/INST] SELECT DISTINCT city FROM branch WHERE membership_amount >= 100 </s>