Database: customers_card_transactions
Question: What are the different account ids that have made financial transactions, as well as how many transactions correspond to each?
SQL:
SELECT account_id ,  count(*) FROM Financial_transactions GROUP BY account_id