text: CREATE TABLE Financial_Transactions (transaction_type VARCHAR) -- Show all transaction types. SELECT DISTINCT transaction_type FROM Financial_Transactions CREATE TABLE Financial_Transactions (transaction_type VARCHAR) -- Show the number of transaction types. SELECT COUNT(DISTINCT transaction_type) FROM Financial_Transactions CREATE TABLE Financial_transactions (transaction_amount INTEGER) -- What is the average and total transaction amount? SELECT AVG(transaction_amount), SUM(transaction_amount) FROM Financial_transactions CREATE TABLE Financial_transactions (card_id VARCHAR); CREATE TABLE Customers_cards (card_type_code VARCHAR, card_id VARCHAR) -- Show the card type codes and the number of transactions. 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 CREATE TABLE Financial_transactions (transaction_type VARCHAR) -- Show the transaction type and the number of transactions. SELECT transaction_type, COUNT(*) FROM Financial_transactions GROUP BY transaction_type CREATE TABLE Financial_transactions (transaction_type VARCHAR, transaction_amount INTEGER) -- What is the transaction type that has processed the greatest total amount in transactions? SELECT transaction_type FROM Financial_transactions GROUP BY transaction_type ORDER BY SUM(transaction_amount) DESC LIMIT 1 CREATE TABLE Financial_transactions (account_id VARCHAR) -- Show the account id and the number of transactions for each account SELECT account_id, COUNT(*) FROM Financial_transactions GROUP BY account_id