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:

CIA

The Central Intelligence Agency, a civilian foreign intelligence service of the federal government of the United States, tasked with gathering, processing, and analyzing national security information.

Chemical Weapons

Weapons that utilize toxic chemicals to inflict harm or death upon enemy forces or civilians, banned under various international laws and treaties due to their brutal nature.

Biological Weapons

Weapons that use bacteria, viruses, or other pathogens as a means of warfare, intended to cause disease or death in humans, animals, or plants.

Nuclear Weapons

Explosive devices that derive their destructive force from nuclear reactions, either fission or a combination of fission and fusion, capable of causing massive destruction.