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

question 22

Multiple Choice

Based on the code 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? The records are grouped by rep number and ordered by rep number.??Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum )

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

---

Definitions:

Folia

Leaf-like folds in the cerebellum that increase its surface area for processing motor information and coordination.

Cerebral Hemispheres

The two halves of the brain, each controlling the opposite side of the body and divided into lobes with specialized functions.

Cerebellum

A part of the brain located at the back and beneath the cerebrum, responsible for coordination of voluntary movements and balance.

Persuasive Messages

Communications designed to convince or influence the audience to adopt a certain point of view or take a specific action.