How to generate the next query

Generate a view, which allows obtaining the full name of the employees, as well as
    the name of the department, position and salary, in which he has worked (that no longer works).