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:

Anxiety-dominated Disturbances

Psychological disorders primarily characterized by excessive fear, worry, and anxiety.

Unconscious

The part of the mind that is inaccessible to the conscious mind but that affects behavior and emotions.

Freud

Sigmund Freud, the founding father of psychoanalysis, a method for treating psychopathology.

Dreams

Mental experiences during sleep involving imagery, emotions, and thoughts, often considered significant in understanding subconscious desires and processing emotions.