What result set will the following query return?
SELECT Item_No
FROM Order_V
WHERE quantity 10;

A) The Item_No of all orders that had more than 10 items
B) The Order_Id of all orders that had more than one item
C) The Order_Id of all orders that had more than 10 items
D) The Item_No of all orders that had 10 or more items

Question

What result set will the following query return? 
SELECT Item_No
FROM Order_V
WHERE quantity > 10;

A) The Item_No of all orders that had more than 10 items
B) The Order_Id of all orders that had more than one item
C) The Order_Id of all orders that had more than 10 items
D) The Item_No of all orders that had 10 or more items

Quizplus · Accepted Answer

The query selects the Item_No from the Order_V view where the quantity is greater than 10, which matches option A.

What Result Set Will the Following Query Return