Based on the code above,list the number,name,credit limit,and balance for all customers with credit limits that exceed their balances.
A) SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimitBalance ;
B) SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimitBalance ;
C) SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimitBalance ;
D) SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

Question

Based on the code above,list the number,name,credit limit,and balance for all customers with credit limits that exceed their balances.​
A) ​SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ;
B) ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;
C) ​SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance ;
D) ​SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

Quizplus · Accepted Answer

This choice selects all the necessary columns (CustomerNum, CustomerName, CreditLimit, Balance) and specifies the condition that only customers with CreditLimit greater than their Balance should be included in the results. Hence, it gives us the list of customers we are looking for. The other choices do not use the correct columns or condition.

Based on the Code Above,list the Number,name,credit Limit,and Balance for All