What are the different customer ids, and how many cards does each one hold?
SELECT customer_id ,  count(*) FROM Customers_cards GROUP BY customer_id
different customer ids refer to customer_id; how many cards each one hold refers to COUNT(*) for each customer_id;