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

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!