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
different card types refers to DISTINCT(card_type_code); how many cards of each type refers to COUNT(*);