SELECT STATEMENT_ID ,  count(*) FROM Accounts GROUP BY STATEMENT_ID
SELECT STATEMENT_ID ,  count(*) FROM Accounts GROUP BY STATEMENT_ID <table_name> : Accounts col : Account_ID | Statement_ID | Account_Details row 1 : 7 | 57 | 495.063 row 2 : 61 | 57 | 930.14 row 3 : 98 | 57 | 6035.84 row 4 : 136 | 57 | 199.52 row 5 : 164 | 192 | 12223.93 row 6 : 209 | 57 | 11130.23 row 7 : 211 | 192 | 1230.454 row 8 : 240 | 192 | 6352.31 row 9 : 262 | 57 | 147.96 row 10 : 280 | 57 | 187.14 row 11 : 321 | 192 | 745.817 row 12 : 346 | 192 | 127.9 row 13 : 414 | 57 | 25.41 row 14 : 427 | 57 | 1168.32 row 15 : 451 | 192 | 658.26
col : Statement_ID | count(*) row 1 : 57 | 9 row 2 : 192 | 6