What are the different account ids that have made financial transactions, as well as how many transactions correspond to each?
SELECT account_id ,  count(*) FROM Financial_transactions GROUP BY account_id
different account ids refers to DISTINCT(account_id); have made financial transactions refers to the presence in Financial_transactions; how many transactions = COUNT(*) for each account_id;