Based on the Code Shown, Which Query Lists the Number

question 65

Multiple Choice

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

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

---

Definitions:

Prepaid Expenses

Expenses paid in advance for goods or services to be received in the future.

Accounts Receivable

Amounts owed to a company by customers for goods or services provided on credit.

Inventories

Assets held for sale in the ordinary course of business, in the process of production for such sale, or in the form of materials or supplies to be consumed in the production process or in the rendering of services.

Depreciation Expense

The allocated portion of the cost of a tangible or physical asset that is charged as an expense over its useful life.