What Result Set Will the Following Query Return

question 105

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

---

Definitions:

SAT Scores

Standardized test scores used in the United States for college admissions, assessing mathematical and verbal reasoning.

Race/Ethnicity

Socially constructed categories that classify individuals based on perceived physical differences, cultural practices, and ancestry.

Asian

Pertaining to or originating from the continent of Asia, or relating to the people, cultures, or languages of Asia.

Spending Money

Disposable income available for non-essential purchases after all living expenses and obligations have been met.