CREATE TABLE Accounts (STATEMENT_ID VARCHAR)

Show all statement id and the number of accounts for each statement.
SELECT STATEMENT_ID, COUNT(*) FROM Accounts GROUP BY STATEMENT_ID
SELECT "STATEMENT_ID", COUNT(*) FROM "Accounts" GROUP BY "STATEMENT_ID"