Question: USE SQL PROGRAMMING List the departments that are doing a terrible job of responding to human resources complaints in a timely manner. Prepare a query
USE SQL PROGRAMMING
List the departments that are doing a terrible job of responding to human resources complaints in a timely manner.
Prepare a query that does the following:
1) Query that counts the total number of human resources complaints
2) The quantity of untimely responses
3) Percentage of untimely responses by each department
Use the formula : (untimely responses/total number of human resources complaints)
4) Display the departments that had at least 150 complaints
5) Show the department that had the highest percentage of untimely responses. Return the department name and percentage of untimely responses.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
