Based on the Code Shown, Which Query Lists the Number

question 15

Multiple Choice

Based on the code shown, which query lists the number, name, and available credit for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A) SELECT CustomerNum, CustomerName AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
• B) SELECT CustomerNum, CustomerName, CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
• C) SELECT CustomerNum, CustomerName, Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
• D) SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

---

Definitions:

Accounting Equation

The fundamental principle of accounting that states assets equal liabilities plus owner's equity, serving as the foundation of the double-entry bookkeeping system.

Customer on Account

Transactions where a customer purchases goods or services on credit, creating an account receivable for the business.

Financial Statement

A formal record of the financial activities of a business, person, or other entity, presenting its financial performance and position at a given point in time.

Specific Date

A particular day singled out from others because of its significance or relevance to an event or action.