• The question is to have list off all employees with the employees with DateOfLeaving coming last and all others sorted ascending order of date of leaving

    Maybe he wanted to say this?

    The question is to have list off all employees with the employees without DateOfLeaving coming last and all others sorted ascending order of date of leaving

    Anyway the two answers which they say being correct have different results, so at least one of them is wrong... #3 in my opinion is wrong and I was very surprised of it when I was told that #2 alone was not correct 😉