Γράψτε κάποιο Λογισμικό
- Status: Closed
- Prize: $10
- Entries Received: 8
We need someone with strong technical skills in Oracle PLSQL for this work.
We have 2 tables in Toad for Oracle.
The 1st table (offices) contains: officeid (number - 4), office (varchar2 - 100)
The 2nd table (transactions) contains: transid (number - 18), officeid (number - 4), transdate (date of transaction), credit (number – 18,2), debit (number – 18,2)
We need to run a query (with select statement) in SQL to do the following:
For each office, we need to see, firstly, the current month, the balance of the previous month, the total credits of the current month, the total debits for the current month and the new balance of the current month.