how to get Employee.id and Manager.id by the biggest workagreement.id

[henkka]

I have areally tricky case for me that I have tried to resolve three days without success.

I have table where there is a Position.id which means the position where the employee is working (for example Developer). Previous position which identifies the position of the superior (For example IT Manager). Then there is Employee.id and Manager.id which indicates the person.

Only unique value is workagreement.id.

Now what I try to do is first find the latest agreement  by Employee.id. Then summarize Employee.id and their managers by that newest workagreement. Please could someone help me with this.

[henkka]

It eventually came out that the data was the  issue. 

[FreemanZ · Accepted solution]

could you also depict your expected result based on the sample data?