• 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.