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:

Adolescent

An adolescent is a person in the transitional stage of physical and psychological development that occurs between childhood and adulthood, typically considered to occur between ages 13 and 19.

Human Chorionic Gonadotropin

Human Chorionic Gonadotropin (hCG) is a hormone produced during pregnancy that supports the normal development of an egg in a woman's ovary and stimulates the release of the egg during ovulation.

Luteinizing Hormone

Luteinizing Hormone is a hormone produced by the anterior pituitary gland, crucial in regulating the reproductive system, including ovulation in females and testosterone production in males.

Follicle-Stimulating Hormone

A hormone secreted by the anterior pituitary gland that stimulates the growth of ovarian follicles in females and sperm production in males.