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;

---

Definitions:

Median

A statistical measure that represents the middle value in a given set of numbers when arranged in order.

Median

A statistical measure representing the middle value in a given set of numbers, arranging them in ascending or descending order.

Statistics Exam

An assessment aimed at evaluating one's understanding and ability to apply statistical methods and analyses.

Standardised Score

A score that has been transformed to fit a specific average and standard deviation, allowing comparison across different tests or populations.