hard20 pts · first answer countswindow-functionssql

Average of everyone else in the team

You want each salesperson compared with the average of the other members of their team, not including themselves. Which option does that in PostgreSQL?

A.AVG(sales) OVER (PARTITION BY team ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)B.AVG(sales) OVER (PARTITION BY team ORDER BY sales ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)C.AVG(sales) OVER (PARTITION BY team ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING EXCLUDE CURRENT ROW)D.AVG(sales) OVER (PARTITION BY team ORDER BY sales ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING)

Discussion 0

Join free to post in the discussion.

Average of everyone else in the team

Discussion 0

Related questions