SQL : Curious inconsistent behaviour from SQL Server in windowed function clauses?

SQL : Curious inconsistent behaviour from SQL Server in windowed function clauses?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a secret feature that I want to reveal to you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Then, type the letters 'awesome' on the keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

A short overview of who I am,
Hello, I am Delphi.
I am happy to help you with your questions.
SQL : Curious inconsistent behaviour from SQL Server in windowed function clauses?
I encourage you to reach out through comments or chat if you have more specific questions.
If you have additional information or an answer to share, please comment below.
Your answer will be appreciated and acknowledged with a 'heart' from me.
function : from Server windowed behaviour clauses? Curious SQL SQL inconsistent in