Database: customers_card_transactions
Question: What are the different customer ids, and how many cards does each one hold?
SQL:
SELECT customer_id ,  count(*) FROM Customers_cards GROUP BY customer_id