Show all card type codes and the number of cards in each type.
SELECT card_type_code ,  count(*) FROM Customers_cards GROUP BY card_type_code
card type codes refers to card_type_code; number of cards in each type refers to COUNT(*);