Show all card type codes and the number of cards in each type.
CREATE TABLE Customers_cards (card_type_code VARCHAR)
SELECT card_type_code, COUNT(*) FROM Customers_cards GROUP BY card_type_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Customers_cards (card_type_code VARCHAR) Question: Show all card type codes and the number of cards in each type. [/INST] SELECT card_type_code, COUNT(*) FROM Customers_cards GROUP BY card_type_code </s>