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

question 63

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:

Profitability Ratio

A category of financial metrics used to assess a business's ability to generate earnings relative to its revenue, assets, equity, or other financial aspects.

Payout Ratio

A financial metric indicating the proportion of earnings a company pays to its shareholders in dividends, expressed as a percentage of the company's net income.

Times Interest Earned

Times Interest Earned is a financial metric that measures a company's ability to meet its interest obligations, calculated as earnings before interest and taxes divided by interest expense.

Inventory Turnover

A ratio indicating how often a company sells and replaces its stock of goods during a period, calculated as cost of goods sold divided by average inventory.