Based on the Code Shown, Which Query Lists the Number

question 15

Multiple Choice

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

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

Particular Activity

A specific action or endeavor undertaken by individuals or groups.

State of Mind

A person’s emotional and psychological condition at a particular time.

Supererogatory Actions

Actions that go beyond what is morally required or expected, typically considered voluntary and commendable but not obligatory.

Kant's Categorical Imperatives

Fundamental principles in Immanuel Kant's ethical theory that command us to act in a universally acceptable way, independent of our desires.