CREATE TABLE accounts (account_id NUMBER, customer_id NUMBER, account_name CLOB, other_account_details CLOB)
CREATE TABLE financial_transactions (transaction_id NUMBER, previous_transaction_id NUMBER, account_id NUMBER, card_id NUMBER, transaction_type CLOB, transaction_date TIME, transaction_amount NUMBER, transaction_comment CLOB, other_transaction_details CLOB)
CREATE TABLE customers_cards (card_id NUMBER, customer_id NUMBER, card_type_code CLOB, card_number CLOB, date_valid_from TIME, date_valid_to TIME, other_card_details CLOB)
CREATE TABLE customers (customer_id NUMBER, customer_first_name CLOB, customer_last_name CLOB, customer_address CLOB, customer_phone CLOB, customer_email CLOB, other_customer_details CLOB)

What are the different card types, and how many transactions have been made with each?
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
SELECT "T2"."card_type_code", COUNT(*) FROM "financial_transactions" "T1" JOIN "customers_cards" "T2" ON "T1"."card_id" = "T2"."card_id" GROUP BY "T2"."card_type_code"