MS SQL Query Help
- or -
Post a project like this3795
$$
- Posted:
- Proposals: 7
- Remote
- #365891
- Awarded
C#, VB, .Net, Java, JSP, XML, HTML, Jquery, Ajax, PHP, MySQL, Codeigniter, API, Weebly, Wix, Python, Ruby, Node.js, SQL, Oracle
Dhaka
PHP | MYSQL | Magento | Joomla | Wordpress | Responsive | Jquery | HTML | CSS | Javascript
Kanpur
160188137054204793276652287946318732555140
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Need to query data to find the unit cost for work completed.
data:
1. number of requests completed (Vol)
2. cost of work (DNIE)
unit cost = DNIE/Vol
I need to group the unit cost by team, month, and by service
The problem I have is, Service to Vol and DNIE is not a direct correlation
Example for Team 'CAMS' and Service 'Open Systems'
I need to take the sum of Service: Open Systems Build and Deploy + Service: Open Systems Anthill for Vol and I need to divide it by the total of DNIE for AU 465573 plus 33% of the total of the DNIE for AU 207497. I don't know how to write the sql for this.
data:
1. number of requests completed (Vol)
2. cost of work (DNIE)
unit cost = DNIE/Vol
I need to group the unit cost by team, month, and by service
The problem I have is, Service to Vol and DNIE is not a direct correlation
Example for Team 'CAMS' and Service 'Open Systems'
I need to take the sum of Service: Open Systems Build and Deploy + Service: Open Systems Anthill for Vol and I need to divide it by the total of DNIE for AU 465573 plus 33% of the total of the DNIE for AU 207497. I don't know how to write the sql for this.
Paul D.
100% (31)Projects Completed
11
Freelancers worked with
11
Projects awarded
47%
Last project
8 Mar 2016
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies