Perform a query showing all employees with their supervisors using the formatting as shown both for fields and column headings. Order by employee last name. Hint: you must use recursion, even if your output looks similar. Use CONCAT() for Supervisor first name, space (' '), and last name. Need MySQL help writing the above query.

I had two answer codes and still did not work with MySQL. in the database I do have all the columns. ReportTo is a internal FK which is the employee id for the employee reporting to.

Query 1-7: Perform a query showing all employees with their supervisors using the formatting as shown both for fields and column headings. Order by employee last name. Hint: you must use recursion, even if your output looks similar. Use CONCAT() for Supervisor first name, space (' '), and last name