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