Question: #2-2 You are asked to write a query that returns the average length of time it takes each pharmacist to verify an order. It is

 #2-2 You are asked to write a query that returns the

#2-2 You are asked to write a query that returns the average length of time it takes each pharmacist to verify an order. It is possible for one order to be verified more than once by the same pharmacist. The query should return one row per pharmacist and count each verification equally regardless of which order it was for. Part 2 of 2 What should the granularity of the query be after GROUP BY is processed? SELECT ONE OF THE FOLLOWING (2 PTS) A. One time an order required verification B. One order C. One pharmacist D. All orders

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!