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

Question

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

Quizplus · Accepted Answer

Choice A correctly selects the customer number, name, and balance for customers with balances between $1,000 and $5,000, inclusive.

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