CREATE TABLE Accounts (Account_ID INT, Statement_ID INT, Account_Details VARCHAR)
CREATE TABLE Projects (Project_ID INT, Project_Details VARCHAR)
CREATE TABLE Ref_Budget_Codes (Budget_Type_Code CHAR, Budget_Type_Description VARCHAR)
CREATE TABLE Ref_Document_Types (Document_Type_Code CHAR, Document_Type_Name VARCHAR, Document_Type_Description VARCHAR)
CREATE TABLE Statements (Statement_ID INT, Statement_Details VARCHAR)
CREATE TABLE Documents_with_Expenses (Document_ID INT, Budget_Type_Code CHAR, Document_Details VARCHAR)
CREATE TABLE Documents (Document_ID INT, Document_Type_Code CHAR, Project_ID INT, Document_Date DATETIME, Document_Name VARCHAR, Document_Description VARCHAR, Other_Details VARCHAR)

what are the different statement ids on accounts, and the number of accounts for each?
SELECT Statement_ID, COUNT(*) FROM Accounts GROUP BY Statement_ID
SELECT "Statement_ID", COUNT(*) FROM "Accounts" GROUP BY "Statement_ID"