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

question 75

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 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 ;