Database: customers_card_transactions
Question: Show all card type codes and the number of customers holding cards in each type.
SQL:
SELECT card_type_code ,  count(DISTINCT customer_id) FROM Customers_cards GROUP BY card_type_code