Solved

Based on the SQL Shown, Which Query Lists the Name

Question 8

Multiple Choice

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;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions