I am not sure if it is worth mentioning but the Average function is a Mean average. In certain situations you may want to find a median average, for which there is no simple function call.
The windowed functions here appear as they would in T-SQL. So that is a nice piece of consistency.
Thank you for sharing.
----------------------------------------------------