>>You're right. For this problem between is clearly a winner.
>
>
>And that's why you don't need a cte
>
>avg of one record = sum/1
>avg of two record = sum/2
CTE in this problem doesn't hurt - you can do with it or without it - no difference.
If it's not broken, fix it until it is.
My Blog