Based on the SQL shown, which query lists the name and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000? Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
A)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
B)SELECT CustomerName, Balance FROM Customers WHERE Balance 2000;
C)SELECT Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
D)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 OR 5000;

Question

Based on the SQL shown, which query lists the name and balance of all customers with balances greater than or equal to $2,000 and less than or equal to $5,000? Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )
A)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
B)SELECT CustomerName, Balance FROM Customers WHERE Balance > 2000;
C)SELECT Balance FROM Customers WHERE Balance BETWEEN 2000 AND 5000;
D)SELECT CustomerName, Balance FROM Customers WHERE Balance BETWEEN 2000 OR 5000;

Quizplus · Accepted Answer

Option A correctly uses the BETWEEN operator to select balances greater than or equal to $2,000 and less than or equal to $5,000, including both the CustomerName and Balance in the output.

Based on the SQL Shown, Which Query Lists the Name