SCHEMA:
CREATE TABLE Customers_cards (card_type_code VARCHAR)
USER:
Show all card type codes and the number of cards in each type.

QUERY:
SELECT card_type_code, COUNT(*) FROM Customers_cards GROUP BY card_type_code