Query 1-7: Perform a query showing all employees with their supervisors using the formatting as shown both for fields and colPerform 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.

There was an answer given but The code did not work it gave an error saying unknown column EmployeeID.

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