in this mysql challenge your query should dertermine the company hierarchical structure based on the position and reportsto columns.

the output should include the position of the individual, their firstname and last name and the position of the person they report to$.$exclude entries where reportsto is null $.$ the result should be ordered by the position of the person they report to and then by the individual position in ascending alphavetical order. the expected column in the outpur are position, firstname, lastname, and reportstoposition