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

Quizplus · Accepted Answer

The query selects the CustomerNum, CustomerName, CreditLimit, and Balance columns and uses the WHERE clause to filter the results to only include customers where the CreditLimit is greater than their Balance. This satisfies the requirement of the question to list only customers whose credit limits exceed their balances.

Based on the Code Shown, Which Query Lists the Number