Task: Text to Code
Input (English): How many transaction does each account have? Show the number and account id.
Output (English): SELECT count(*) ,  account_id FROM Financial_transactions