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:

Respondents

Individuals who answer or respond to surveys, questionnaires, or research studies.

Online Surveys

Tools used for conducting surveys over the internet to collect data or opinions from a wide audience at a relatively low cost.

Email Surveys

A technique for gathering information and responses by distributing questionnaires to participants through email.

Pop-Up Blocker

A software feature or tool designed to prevent pop-up windows, frequently used for advertisements, from opening on a webpage.