I Need SQL Developer
Budget: £10 – £20 GBP
This taks is generatee SQL report for accouting data.
Objective
The objective of this exercise is to produce a summary with a single row per Region totalling the Local, Inbound and Outbound revenue for each Service Line, and with a column for Total TER.
The Service Line totals must include all revenue attributable to or shared by that Service Line. The Total TER should be the total for the Region as reported. .
Deliverables
1. The summary output described in the “Objective” section above
2. The SQL used to produce the summary output, included any steps taken to structure or format the data from its original form
3. Any supporting commentary you see fit e.g. assumptions made
Objective
The objective of this exercise is to produce a summary with a single row per Region totalling the Local, Inbound and Outbound revenue for each Service Line, and with a column for Total TER.
The Service Line totals must include all revenue attributable to or shared by that Service Line. The Total TER should be the total for the Region as reported. .
Deliverables
1. The summary output described in the “Objective” section above
2. The SQL used to produce the summary output, included any steps taken to structure or format the data from its original form
3. Any supporting commentary you see fit e.g. assumptions made