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:

Kalanchoe

A genus of succulent flowering plants that are known for their unique water retention capabilities and often used in decorative gardening.

Chlorophytum

A genus of perennial flowering plants, commonly known as spider plants, notable for their easy care and air-purifying qualities.

Asexually

The process by which an organism can reproduce and generate offspring without the need for a mating partner, resulting in a genetic clone of the parent.

Suckers

An organ in some animals specialized for adhesion, or a shoot from the base of a plant stem that can develop into a new plant.