CREATE TABLE Financial_transactions (transaction_type VARCHAR2, transaction_amount NUMBER)

Show the transaction types and the total amount of transactions.
SELECT transaction_type, SUM(transaction_amount) FROM Financial_transactions GROUP BY transaction_type
SELECT "transaction_type", SUM("transaction_amount") FROM "Financial_transactions" GROUP BY "transaction_type"