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:

Hull's Model

A theory proposed by Clark Hull that describes behavior as the outcome of internal drives, environmental stimuli, and reinforcement.

Reward

A positive consequence or incentive that increases the likelihood of a behavior being repeated.

Drive Reduction

A theory in psychology suggesting that behaviors are motivated by the desire to reduce internal drives such as hunger or thirst.

Hull's Model

A drive-reduction theory of learning and motivation that describes behavior as responses to the reduction of basic physiological needs.