Database: customers_and_invoices
Question: What are total transaction amounts for each transaction type?
SQL:
SELECT transaction_type ,  sum(transaction_amount) FROM Financial_transactions GROUP BY transaction_type