Based on the Code Shown, Which Query Lists the Number

Multiple Choice

Based on the code shown, which query lists the number, name, credit limit, and balance for all customers with credit limits that exceed their balances???Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

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 ;