Given the Table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the Standard SQL Query to Retrieve

question 33

Essay

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance),write the standard SQL query to retrieve the Name and PhoneNumber of customers with a balance greater than 50.

---

Definitions:

Range

The difference between the highest and lowest values in a set of data.

Standard Deviation

A measure that quantifies the amount of variation or dispersion of a set of data values, showing how much variation there is from the mean.

Variance

The measure of spread in a distribution, representing the average of the squared differences from the mean.

Measures of Center

Quantitative measures that describe the central tendency of a data set, including mean, median, and mode.