Based on the SQL Shown, Which Query Lists the Name

question 8

Multiple Choice

Based on the SQL shown, which query lists the name and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000? Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
• B)SELECT CustomerName, Balance FROM Customers WHERE Balance > 2000;
• C)SELECT Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
• D)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 OR 5000;

---

Definitions:

Markup Percentage

The percentage added to the cost of a product to calculate the selling price, based on desired profit.

Special Project

A designated set of tasks or activities aimed at achieving a specific goal or outcome, often outside of routine operations.

Relevant Cost

refers to the costs that will be affected by a decision in the future and, thus, should be considered in decision-making processes.

Discounted Price

A reduced price offered on goods or services, usually for a limited time or under certain conditions.