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:

Electronic Junk Mail

Unwanted or unsolicited email, often of a commercial nature, sent in bulk to a large list of recipients.

Unsolicited E-Mail

Email that is sent without the recipient's prior consent or request, often considered spam.

Viral Marketing

A marketing technique that uses social networks to promote a product, typically encouraging individuals to share information and content about the product with others.

Sweepstakes

A promotional strategy that involves giving away prizes to randomly selected participants, often used to attract attention or gather consumer data.