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 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
Get step-by-step solutions from verified subject matter experts
