**Data should be sorted in ascending order by Employee Last Name Instructions: For this assignment, write a query that produces the results described above. Assume that you are running the report for the 2013 calendar year. As in the previous report, in the real-world, you would likely use the getdate() function to determine the current date and run the report from the beginning of the current year until the present time. For this assignment, however, you may hardcode the year 2013 in your query and retrieve all of the data for that year. Management Exception reporting Management must keep track of employees whose combined hours have exceeded the maximum allowed hours on projects. This report must be run before invoicing occurs in order to prevent billing in excess of contractual amounts. Show only projects whose cap amounts have been exceeded. Project Name Maximum allowed hours per project Total hours worked on project Overage (the difference between the cap and actual hours) **Sort data by Project Name In a separate show the details for the projects whose cap amounts have been exceeded: Project Name Employees who worked on project Total hours worked on project per employee **Sort data by Project Name, then by employees who worked on the project Instructions: For this assignment, write a query for 4(a) and a separate query for 4(b). The results should reflect the requirements described above. Payroll The Payroll department requires a report of employees who are logging more hours per week than they are legally required to work per country stipulations. These employees are paid overtime wages for hours worked in excess of weekly stipulated hours.
**Data should be sorted in ascending order by Employee Last Name Instructions: For this assignment, write a query that produces the results described above. Assume that you are running the report for the 2013 calendar year. As in the previous report, in the real-world, you would likely use the getdate() function to determine the current date and run the report from the beginning of the current year until the present time. For this assignment, however, you may hardcode the year 2013 in your query and retrieve all of the data for that year. Management Exception reporting Management must keep track of employees whose combined hours have exceeded the maximum allowed hours on projects. This report must be run before invoicing occurs in order to prevent billing in excess of contractual amounts. Show only projects whose cap amounts have been exceeded. Project Name Maximum allowed hours per project Total hours worked on project Overage (the difference between the cap and actual hours) **Sort data by Project Name In a separate show the details for the projects whose cap amounts have been exceeded: Project Name Employees who worked on project Total hours worked on project per employee **Sort data by Project Name, then by employees who worked on the project Instructions: For this assignment, write a query for 4(a) and a separate query for 4(b). The results should reflect the requirements described above. Payroll The Payroll department requires a report of employees who are logging more hours per week than they are legally required to work per country stipulations. These employees are paid overtime wages for hours worked in excess of weekly stipulated hours.
1799_CMS-Project-Phase-II-Instructions-3-.docx