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 ;
Correct Answer:

Verified
Correct Answer:
Verified
Q53: You use the SQL _ command to
Q65: The _ clause can be used to
Q66: Based on the code above,find how many
Q67: Based on the code above,list the number
Q68: When used after the word SELECT,the _
Q69: When you use a name containing a
Q70: The _ data type stores integers,but uses
Q72: When you need to sort data on
Q73: A field whose values you derive from
Q74: Many versions of SQL require you to