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

question 56

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;

---

Definitions:

Married

The state of being united to a person as a spouse through legal, cultural, or religious ceremonies.

Marital Stability

The condition of a marriage characterized by enduring relationships, lack of conflict, and the ability to maintain a healthy and lasting partnership.

Marital Satisfaction

The degree of contentment and fulfillment individuals feel in their marital relationship.

College Education

A post-secondary education program leading to an undergraduate or graduate degree, typically involving a combination of lectures, examinations, and research.