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
SELECT "transaction_type", COUNT(*) FROM "Financial_transactions" GROUP BY "transaction_type"