SQL查询与最大作业周期有关

I am having a table with four columns namely, eid,ename,hire_date and end_date. Now I want to write a query displaying the name and id of the employee who has worked for the maximum days and the no. of days for which he/she has worked. I have tried a lot but unfortunately I am not getting the desired answer.I am having a table with four columns namely, e