Show minimum and maximum amount of memberships for all branches opened in 2011 or located at city London.
CREATE TABLE branch (membership_amount INTEGER, open_year VARCHAR, city VARCHAR)
SELECT MIN(membership_amount), MAX(membership_amount) FROM branch WHERE open_year = 2011 OR city = 'London'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE branch (membership_amount INTEGER, open_year VARCHAR, city VARCHAR) Question: Show minimum and maximum amount of memberships for all branches opened in 2011 or located at city London. [/INST] SELECT MIN(membership_amount), MAX(membership_amount) FROM branch WHERE open_year = 2011 OR city = 'London' </s>