so that means Brenda Smith was subordinator of Alexander Tuckings
Why? Why not a subordinate of someone else?
There is no ordering of data and there is no way for SQL to know that one job title is 'lower' than another.
The usual way of accomplishing such a task is to include another couple of columns in your data:
1) PersonId - uniquely identifies a person
2) ManagerId - a foreign key back to PersonId
Without these, I can't see an easy way forward for you.