Multiple Choice
Based on the code above,list the number,name,and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000.
A) SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
B) SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance > 2000 ;
C) SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
D) SELECT CustomerNum, CustomerName FROM Customer WHERE Balance BETWEEN 2000 AND 5000 ;
Correct Answer:

Verified
Correct Answer:
Verified
Q15: Based on the code above,for each sales
Q17: The HAVING clause is to groups what
Q18: CHAR data types are numbers without a
Q20: For each pair of tables to be
Q22: To add new data to a table,use
Q23: Preceding a condition by the NOT operator
Q32: A valid name for a table might
Q43: Describe five data types that you will
Q58: Discuss the restriction about the structure of
Q63: By using the word _ in a