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:

Metalinguistic Awareness

The ability to think about and reflect on the nature of language itself, including its structure, function, and use.

Holophrases

Single words used by infants that represent complex ideas or whole sentences, a part of early language development.

Private Speech

The act of talking to oneself, often seen in young children as a way of guiding their own behavior.

Telegraphic Speech

The early speech phase in children where sentences are formed with only essential words, omitting smaller ones or grammatical elements.