Based on the Tables Below,which of the Following ANSI SQL

question 9

Multiple Choice

Based on the tables below,which of the following ANSI SQL commands would return the average customer balance grouped by SalesRepNo? GENERAL SALES DATABASE:
SALESREP

CUSTOMER

• A)SELECT AVG (Balance) FROM CUSTOMER WHERE SalesRepNo;
• B)SELECT AVG (Balance) FROM CUSTOMER GROUP BY SalesRepNo;
• C)SELECT AVG (Balance) FROM CUSTOMER,SALESREP WHERE SALESREP.SalesRepNo = CUSTOMER.SalesRepNo;
• D)SELECT AVG (Balance) FROM CUSTOMER ORDER BY SalesRepNo;
• E)SELECT AVG (Balanc
• E) FROM CUSTOMER,SALESREP WHERE CUSTOMER.SalesRepNo = CUSTOMER.SalesRepNo HAVING SalesRepNo;

---

Definitions:

Statistically Significant

A term indicating that the likelihood a result happened by chance is low, often used in research to confirm the reliability of findings.

Variability

The degree to which data points in a statistical distribution or set diverge from the average value and from each other.

Samples

Selected groups or portions of a population used in research to draw conclusions about the overall population based on their characteristics or responses.

Standard Deviation

A statistical measure that quantifies the variation or dispersion of a set of data points relative to its mean.