What Result Set Will the Following Query Return? Select Item_No

Multiple Choice

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