Based on the SQL Shown, Which Query Lists the Name

question 24

Multiple Choice

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

• A)SELECT CustomerName AS AvailableCredit FROM Customers WHERE CreditLimit > Balance;
• B)SELECT CustomerName, CreditLimit AS AvailableCredit FROM Customers WHERE CreditLimit > Balance;
• C)SELECT CustomerName, Balance AS AvailableCredit FROM Customers WHERE CreditLimit > Balance ;
• D)SELECT CustomerName, CreditLimit - Balance AS AvailableCredit FROM Customers WHERE CreditLimit > Balance;

---

Definitions:

Phylum

A major classification of living organisms, ranking above class and below kingdom, that groups together organisms with a common basic structure.

Phylum

A rank in the biological taxonomy that is below kingdom and above class, used to group organisms that share basic structural or developmental characteristics.

Phylum

A level of classification in the biological taxonomy that groups together organisms based on a common plan of body structure or organization.

Phylum

A phylum is a rank of classification in biology that groups together organisms with a similar body plan or significant shared characteristics.