Database: customers_and_invoices
Question: Show the transaction types and the total amount of transactions.
SQL:
SELECT transaction_type ,  sum(transaction_amount) FROM Financial_transactions GROUP BY transaction_type