Database: customers_card_transactions
Question: What are the different card types, and how many cards are there of each?
SQL:
SELECT card_type_code ,  count(*) FROM Customers_cards GROUP BY card_type_code