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:

Balance Sheet

A summary that encapsulates a business's liabilities, assets, and shareholders' equity at a distinct date.

Worksheet

A paper or electronic document with rows and columns, used for organizing, calculating, and presenting financial information.

Depreciation Expense

An accounting method of allocating the cost of a tangible asset over its useful life, reflecting wear and tear or obsolescence.

Prepaid Insurance

An asset account that represents insurance premiums paid in advance, which have not yet expired at the time of the balance sheet.