Task: Text to Code
Input (English): Step 1: For each row in Customers_Cards table, find the corresponding rows in Financial_Transactions table.
Step 2: find each value of transaction_type in the results of step 1 along with the number of the corresponding rows to each value
Output (English): SELECT T1.card_type_code , Count ( * ) FROM Customers_Cards AS T1 JOIN Financial_Transactions AS T2 ON T1.card_id = T2.card_id GROUP BY T2.transaction_type