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:

Written Constitution

A formal document outlining the structure, functions, and powers of a government and the rights of the citizens, serving as the supreme law of the land.

Membership Dues

Membership dues refer to the fees individuals or entities pay regularly to belong to an organization, club, or group, providing them access to membership benefits and privileges.

U.S. Third Party

Political parties in the United States that operate outside of the traditionally dominant Democratic and Republican parties, often advocating specific or alternative policies.

National Vote

The aggregated preference of voters across a nation, especially evident in nationwide elections for leadership or policy referendums.