Based on the Code Above,list the Number,name,and Available Credit for All

question 57

Multiple Choice

Based on the code above,list the number,name,and available credit for all customers with credit limits that exceed their balances.​

• 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:

Limited Partnership

A business structure with at least one general partner who manages the business and assumes unlimited liability, and one or more limited partners who provide capital and have limited liability.

Limited Partnership

A partnership structure where at least one partner has unlimited liability (general partner) and one or more partners have limited liability (limited partners), restricting their losses to their investment in the partnership.

Limited Liability Partnership

A business structure where partners have limited liabilities, protecting personal assets from the debts of the business.

Sole Proprietorship

A sole proprietorship is a business owned and operated by a single individual, where there is no legal separation between the owner and the business entity.