What result set will the following query return?
SELECT Item_No, description
FROM item
WHERE weight > 100 and weight < 200;

Question

What result set will the following query return? 
SELECT Item_No, description
FROM item
WHERE weight > 100 and weight < 200;

A) The Item_No and description for all items weighing less than 100
B) The Item_No for all items weighing between 101 and 199
C) The Item_No and description for all items weighing between 101 and 199
D) The Item_No for all items weighing more than 200

Quizplus · Accepted Answer

The query selects both Item_No and description for items with a weight greater than 100 and less than 200, which means it includes items weighing between 101 and 199.

What Result Set Will the Following Query Return