GROUPING 5 2 The following SQL query retums one row per surgeon The granularity before GROUP BY is a surgeon panel combination, in other words, for coch surgeon, one panel they performed in Surgeons aan only be listed once per panel, but a log con hove more than one panel SELECT staff STAFF NM WID Surgeon , COUNT( OP LOG 10 ) Number of Logs FROM OR LOG or1 INNER JOIN V LOG STAFF staff ON or LOG ID staff LOG ID INNER JOIN OR LOG ALL PROC procs ON orl LOG ID procs LOG 10 AND procs LINE 1 First listed procedure WHERE staff STAFF TYPE MAP NM 'Physician GROUP BY stoff STAFF NM WID Ponels are identified by the column procs ALL PROCS PANEL Logs are identified by the column orl LOG 10 Part 2 of 2 Which of the following steps are necessary to count the number of logs a surgeon performed in, while avoiding counting logs twice when a surgeon performed in more than one panel SELECT ONE OF THE FOLLOWING (1 PT) A Change SELECT to SELECT DISTINCT B Change COUNT( ortLOG ID ) to DISTINCT COUNT( od LOG ID) C Change COUNT( Orl LOG ID ) to COUNT( DISTINCT OR LOG ID) D None of the above

Question

GROUPING  5 2 The following SQL query retums one row per surgeon  The granularity before GROUP BY is a surgeon panel combination, in other words, for coch surgeon, one panel they performed in  Surgeons aan only be listed once per panel, but a log con hove more than one panel  SELECT staff  STAFF NM WID Surgeon , COUNT( OP LOG 10 ) Number of Logs  FROM OR LOG or1 INNER JOIN V LOG STAFF staff ON or LOG ID   staff LOG ID INNER JOIN OR LOG ALL PROC procs ON orl LOG ID   procs LOG 10 AND procs  LINE   1   First listed procedure WHERE staff STAFF TYPE MAP NM   'Physician GROUP BY stoff  STAFF NM WID Ponels are identified by the column procs ALL PROCS PANEL  Logs are identified by the column orl LOG 10  Part 2 of 2 Which of the following steps are necessary to count the number of logs a surgeon performed in, while avoiding counting logs twice when a surgeon performed in more than one panel  SELECT ONE OF THE FOLLOWING (1 PT) A  Change   SELECT to  SELECT DISTINCT  B  Change COUNT( ortLOG ID ) to  DISTINCT COUNT( od LOG ID)  C  Change COUNT( Orl LOG ID ) to COUNT( DISTINCT OR LOG ID)  D  None of the above

Accepted Answer

The Answer is in the image, click to view ...

Question

GROUPING #5-2 The following SQL query retums one row per surgeon. The granularity before GROUP BY is a surgeon panel combination, in other words, for

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Database Processing

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question