1) Query data from transaction table and calculate the total balance in each account 2) Query data from transaction table and calculate total amount debited by cheque, dd and by cash for each account.