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;

Question

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;

Quizplus · Accepted Answer

The correct query is D because it selects the customer name and calculates the available credit by subtracting the balance from the credit limit for customers whose credit limit exceeds their balance.

Based on the SQL Shown, Which Query Lists the Name