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

question 73

Multiple Choice

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 ;