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 ;

Question

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 ;

Quizplus · Accepted Answer

This query selects the CustomerNum, CustomerName, and Balance columns from the Customer table where the Balance is between $2,000 and $5,000. This will provide a list of all customers with balances in that range.

Based on the Code Above,list the Number,name,and Balance of All