Based on the SQL Shown, for Each Sales Rep, Which

question 47

Multiple Choice

Based on the SQL shown, for each sales rep, which query lists the rep number, the number of customers assigned to the rep, and the average balance of the rep's customers? Group and order the records by rep number. Customers ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

• A)SELECT RepNum, AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
• B)SELECT RepNum, COUNT(RepNum), AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
• C)SELECT RepNum, COUNT(*), AVG(Balance) FROM Customers GROUP BY RepNum ORDER BY RepNum;
• D)SELECT RepNum, COUNT(*) FROM Customers GROUP BY RepNum ORDER BY RepNum;

---

Definitions:

Profit Centers

Divisions or units within an organization that are directly responsible for generating its profit.

Statements Of Activities

Financial reports that summarize an organization's revenues, expenses, and changes in net assets for a specific period.

Statements Of Cash Flows

Financial statements that detail the inflow and outflow of cash within an organization over a specific period of time.

Statements Of Functional Expenses

Financial reports that categorize an organization's expenses according to their purpose, such as program services, administration, or fundraising.