Database: customers_card_transactions
Question: Show all customer ids and the number of cards owned by each customer.
SQL:
SELECT customer_id ,  count(*) FROM Customers_cards GROUP BY customer_id