Only option 2 gives result as shown in the question, but reading back the question, I get really confused if that even was what was asked.
The question is to have list off all employees with the employees with DateOfLeaving coming last
Doesn't this mean that employees without DateOfLeaving (the null values), should be first in the result set?!
Guess the only good solution is to give everybody their points 😀