Schema: CREATE TABLE Customers_cards (card_type_code VARCHAR, customer_id VARCHAR)
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