Find the number of members living in each address.
CREATE TABLE member (address VARCHAR)
SELECT COUNT(*), address FROM member GROUP BY address
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE member (address VARCHAR) Question: Find the number of members living in each address. [/INST] SELECT COUNT(*), address FROM member GROUP BY address </s>