Task: Text to Code
Input (English): What are the different card types, and how many cards are there of each?
Output (English): SELECT card_type_code ,  count(*) FROM Customers_cards GROUP BY card_type_code