What Result Set Will the Following Query Return

question 6

Multiple Choice

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