I have issues with writing the query to solve the question 5
This is the question below
Write a query that returns information about each employee and their supervisor.
- The report should include employees even if they do not report to another employee.
- The report should be sorted alphabetically by the
- Your query should return the following columns, in order:
employee_name- containing the
last_namecolumns separated by a space, eg
employee_title- the title of that employee
supervisor_name- the first and last name of the person the employee reports to, in the same format as
supervisor_title- the title of the person the employee reports to
I have attached a screenshot of my attempt to answer it and the error thrown!