Database: customers_card_transactions
Question: Show the account id and the number of transactions for each account
SQL:
SELECT account_id ,  count(*) FROM Financial_transactions GROUP BY account_id