What is the output of this query?

select case when null = null then 'Yes' else 'No' end as Result;

Because null always not equal to another null.

Null is consider to be a memory reference. So each null will take different reference ID.
So NULL will be not equal anytime.