SELECT card_type_code ,  count(*) FROM Customers_cards GROUP BY card_type_code
What are the different card types, and how many cards are there of each?
SELECT card_type_code , count ( * ) FROM Customers_cards GROUP BY card_type_code
select card_type_code , count ( * ) from customers_cards group by card_type_code
What are the different card types , and how many cards are there of each ?