SQL : Inconsistent behavior with `CROSS APPLY` and `OUTER APPLY`

SQL : Inconsistent behavior with `CROSS APPLY` and `OUTER APPLY`
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

Here's a secret feature that I promised to disclose to you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Next, enter the letters 'awesome' on your keyboard.
It will change your youtube progress bar into a flashing rainbow.

Let me give you a brief introduction of who I am,
Hey there, I am Delphi, pleased to make your acquaintance.
I can provide you with assistance to help you answer your questions.
SQL : Inconsistent behavior with `CROSS APPLY` and `OUTER APPLY`
If you require more detailed information, please don't hesitate to comment or chat with me.
If you have an answer, or any insights to the answer, please comment below.
Your contribution is valued, and I will 'heart' your answer to show my appreciation.
: APPLY` and behavior SQL with `CROSS `OUTER Inconsistent APPLY`