|
Title: Based on the code above, list the number, name, credit limit, and balance for all customers with ... Post by: batuayan on Jan 31, 2018 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 ; Title: Based on the code above, list the number, name, credit limit, and balance for all customers with ... Post by: red ridinghood on Jan 31, 2018 Content hidden
|