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;

Manipulate and simplify polynomial expressions.

Solve algebraic equations for specific variables.

Simplify expressions involving powers and roots.

Understand and apply properties of exponents in algebra.

---

Definitions:

Retrograde Amnesia

A loss of memory for events that occurred before a certain point in time, often due to brain injury or diseases.

Anterograde Amnesia

An inability to form new memories following the onset of an amnesia-causing event, though long-term memories from before the event may remain intact.

Hippocampus

A region of the brain associated with the formation of new memories and spatial navigation.

Anterograde Amnesia

A loss of the ability to create new memories after the event that caused the amnesia, leading to a partial or complete inability to recall the recent past, while long-term memories from before the event remain intact.