Based on the SQL Shown, Which Query Lists the Name

question 24

Multiple Choice

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

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

---

Definitions:

Balance Sheet Columns

The sections in a balance sheet that typically include assets, liabilities, and shareholders' equity.

Balance Sheet

A financial summary capturing a company’s assets, obligations, and shareholders’ equity at a particular instant.

Ending Retained Earnings

The portion of net income left after dividends have been distributed to shareholders, reflected at the end of an accounting period.

Work Sheet

A work sheet is an informal business document used for preparing financial statements and facilitating the end-of-period accounting process, often in an Excel spreadsheet or similar format.