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

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,CreditLimit,Balance FROM Customer ;
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 FROM Customer WHERE CreditLimit>Balance ;

Quizplus · Accepted Answer

This choice uses a WHERE clause to filter for only customers whose CreditLimit is greater than their Balance, which is the requirement given in the question. It also includes all the necessary columns (CustomerNum, CustomerName, CreditLimit, and Balance), allowing for easy identification of the required information. Option A includes unnecessary column (we don't need the NAME to list the customers) and will require further processing of the data. Option C includes unnecessary column (CREDIT LIMIT) and will require further processing of the data. Option D will not include the credit limit and balance of the customers which are required in the question.

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