Question: WHAT WILL THIS QUERY RETURN? SELECT rxi.VALUE ,rxi.ORDERS_ID FROM RX_INTERVENTION rxi LEFT OUTER JOIN RX_IVENT_ORDERS rxiord ON rxi.INTERVENTION_ID = rxiord.INTERVENTION_ID WHERE ( rxi.STATUS_C =2 OR
WHAT WILL THIS QUERY RETURN?
SELECT rxi.VALUE ,rxi.ORDERS_ID FROM RX_INTERVENTION rxi LEFT OUTER JOIN RX_IVENT_ORDERS rxiord ON rxi.INTERVENTION_ID = rxiord.INTERVENTION_ID WHERE ( rxi.STATUS_C =2 OR rxi.STATUS_C > = 2000) -- Closed Interventions AND rxi.TIME_SPENT > 10 AND rxi.SCORING_SYSTEM_ID IS NULL
A) All interventions, with or without attached orders, on which more than 10 minutes were spent B) All interventions with attached orders, on which more than 10 minutes were spent C) Closed interventions, with or without attached orders, on which more than 10 minutes were spent D) Closed interventions with attached orders, on which more than 10 minutes were spent
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
