SELECT customer_id ,  count(*) FROM Customers_cards GROUP BY customer_id
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
select customer_id , count ( * ) from customers_cards group by customer_id
What are the different customer ids , and how many cards does each one hold ?