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:

Blood Pressure Device

A medical instrument used to measure the pressure of blood in the arteries.

Heart Rhythms

The pattern of beats produced by the heart as it pumps blood through the body, which can be regular or irregular.

Hypertension

A chronic medical condition in which the blood pressure in the arteries is persistently elevated, leading to increased risk of heart disease, stroke, and other health issues.

Electronic Blood Pressure Device

A digital device used to measure blood pressure, providing systolic and diastolic readings electronically.