Based on the Code Shown, Which Query Lists the Number

question 34

Multiple Choice

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

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

---

Definitions:

Owner Withdraws

Transactions where the owner of a sole proprietorship takes out cash or other assets from the business for personal use.

General Journal

A comprehensive record where all financial transactions of a business are originally entered before being transferred to specific accounts in the general ledger.

Cash Payments Journal

A financial journal that records all cash payments or outflows of a business.

Sales Journal

A specialized accounting journal used to record all sales transactions of a business.