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:

Margin Call

A request from a broker to an investor to add more funds or securities to compensate for potential losses.

Short 100 Shares

The act of selling 100 shares of stock not currently owned, with the expectation that the stock can be bought back at a lower price in the future for profit.

Rate of Return

A measure of the gain or loss on an investment over a specified period, expressed as a percentage of the investment's initial cost.

Short 100 Shares

Short 100 Shares refers to the investment strategy where an investor borrows 100 shares of a stock with the aim of selling them with the expectation that their price will decline.