Given the Table CUSTOMER(CustID,Name,PhoneNum,AcctBalance)

question 57

Multiple Choice

Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

• A) WHERE CUSTOMER-AcctBalance > 50
• B) WHERE (CUSTOMER-AcctBalance > 50)
• C) WHERE AcctBalance > 50
• D) WHERE (AcctBalance > 50)
• E) HAVING AcctBalance > 50

---

Definitions:

Sample standard deviation

A statistic that measures the dispersion of a dataset relative to its mean and is calculated as the square root of the variance.

True average age

The actual mean age of all individuals in a specified group or population.

Defective parts

Components or units that fail to meet the quality standards or specifications.

Sample size

The number of observations or data points collected from a population for a study.