Show the card type codes and the number of transactions.
CREATE TABLE Customers_cards (
    card_type_code VARCHAR,
    card_id VARCHAR
)

CREATE TABLE Financial_transactions (
    card_id VARCHAR
)
SELECT T2.card_type_code, COUNT(*) FROM Financial_transactions AS T1 JOIN Customers_cards AS T2 ON T1.card_id = T2.card_id GROUP BY T2.card_type_code
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the card type codes and the number of transactions. ### Input: CREATE TABLE Customers_cards (
    card_type_code VARCHAR,
    card_id VARCHAR
)

CREATE TABLE Financial_transactions (
    card_id VARCHAR
) ### Response: SELECT T2.card_type_code, COUNT(*) FROM Financial_transactions AS T1 JOIN Customers_cards AS T2 ON T1.card_id = T2.card_id GROUP BY T2.card_type_code