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 CreditLimitBalance ;
B) SELECT CustomerNum, CustomerName, CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimitBalance ;
C) SELECT CustomerNum, CustomerName, Balance AS AvailableCredit FROM Customer WHERE CreditLimitBalance ;
D) SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimitBalance ;

Question

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 ;

Quizplus · Accepted Answer

The correct choice is D because it lists the CustomerNum, CustomerName, and the difference between credit limit and balance as the AvailableCredit for all customers with credit limits that exceed their balances. This is achieved by subtracting the Balance from the CreditLimit in the SELECT statement of the query. Options A and C do not provide the correct information for AvailableCredit, while option B lists CreditLimit as the AvailableCredit, which is not accurate for customers with credit limits that exceed their balances.

Based on the Code Above,list the Number,name,and Available Credit for All