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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!