The given answer here is wrong which is not displaying the dateofleaving in ascending order.

I think the correct answer is,

select * from employees

order by dateofleaving desc,empname asc