Task: Text to Code
Input (English): SQL: SELECT transaction_type , Count ( * ) FROM Financial_Transactions GROUP BY transaction_type
Feedback: Replace transaction type in financial transactions table with distinct card type code in customers cards , corresponding rows to each value of transaction made .
Output (English): 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