Based on the Code Above,for Each Sales Rep,list the Rep

question 15

Multiple Choice

Based on the code above,for each sales rep,list the rep number,the number of customers assigned to the rep,and the average balance of the rep's customers.Group the records by rep number and order the records by rep number.​

• 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:

Gland

An organ in the human or animal body that secretes particular chemical substances for use in the body or for discharge into the surroundings.

Growth Hormone

A hormone that stimulates growth, cell reproduction, and cell regeneration in humans and other animals. It is crucial for human development.

Acromegaly

A hormonal disorder that results from the excess growth hormone, leading to enlarged bones in hands, feet, and face.

Adrenalectomy

A surgical procedure to remove one or both adrenal glands, which are located above the kidneys.