I would like to know if I can get the average of a sum in one single SQL SERVER request,
Have tried to do it with the following request but it doesn't work:
SELECT t.client,
AVG(SUM(t.asset)) AS Expr1
FROM TABLE t
GROUP BY t.client
See Question&Answers more detail:os