Show all statement id and the number of accounts for each statement.
CREATE TABLE Accounts (STATEMENT_ID VARCHAR)
SELECT STATEMENT_ID, COUNT(*) FROM Accounts GROUP BY STATEMENT_ID
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Accounts (STATEMENT_ID VARCHAR) Question: Show all statement id and the number of accounts for each statement. [/INST] SELECT STATEMENT_ID, COUNT(*) FROM Accounts GROUP BY STATEMENT_ID </s>