Database: customers_card_transactions
Question: How many accounts are there for each customer id?
SQL:
SELECT customer_id ,  count(*) FROM Accounts GROUP BY customer_id