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:

Psychology Research

The scientific study of the mind and behavior, including understanding mental functions, brain functions, and behaviors through various research methodologies.

Overrepresented

Having a disproportionately large presence or quantity in a particular context or area.

Ethical Principle

A fundamental guideline or rule that helps determine the rightness or wrongness of actions, often used in moral reasoning and decision-making processes.

Sexual Deviance

A term describing sexual behavior that deviates from societal norms and expectations.