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