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:

Pons

A crucial structure in the brainstem that plays key roles in sleep and dreaming, arousal, and coordination of movement.

Brain Stem

The central trunk of the mammalian brain, connecting the brain to the spinal cord and responsible for controlling basic functions like breathing and heart rate.

Pons

A part of the brainstem that plays key roles in regulating breathing, communication between different parts of the brain, and sensations such as hearing, taste, and balance.

Breathing

The process of inhaling and exhaling air to facilitate gas exchange with the internal environment, primarily by bringing in oxygen and flushing out carbon dioxide.