What are the different transaction types, and how many transactions of each have taken place?
SELECT transaction_type ,  count(*) FROM Financial_transactions GROUP BY transaction_type
different transaction types refers to DISTINCT(transaction_type); how many transactions of each have taken place refers to COUNT(*) GROUP BY transaction_type;