What Result Set Will the Following Query Return? Select Item_No

question 3

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:

On-site Restaurants

Eateries located within an establishment, such as a business center or corporate office building, providing convenient dining options for employees and visitors.

Medical Benefits

Health-related benefits provided by employers or government programs, which may include medical insurance, dental care, vision care, and prescription drug coverage among others.

Family-friendly Benefit

Employment benefits designed to accommodate employees' family needs, such as flexible working hours, parental leave, and childcare services.

Work-Life Balance

A concept that emphasizes the importance of having equilibrium among work activities, personal life, and family life to ensure overall well-being.