As Dave mentioned - there is no relationship rule given. So it is not possible to come up with the output that the OP is asking for.

But I suspect that the OP wants to use the [Position] column to tell the parent-child/manager-employee/Darth Vader-Luke Vader relationship.

So, the heirarchy goes:

[CEO] is root

-> [President *] next

-> -> [VP *] next

-> -> -> [Team Lead *] next

-> -> -> -> [Senior *] last

There are some obvious issues with this rule. [What happens if you are a Senior VP]?

This is what I could think of...

Sunil