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

Multiple Choice

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 ;