CIS 4338

Hello I need help in how to create a self join this are the directions:

"Self-Join. Write a query that is a self-join that, when executed, returns a list of employees with the name of their supervisor, provided the supervisor value for the employee is either an employee name that is also in the table or an employee email that is also in the table. Futher, if an employee has no supervisor value, then this information should be returned, too. Be sure to use column aliases so that the results show which people are the supervisors and which are the employees. "

I have also attach a screenshot of my employee table:

Columns Data | Model |Constraints Grants Statistics Triggers Flashback IDependencies |Details Partions Indexes IsQL Actions COLLMN NAMEDATA TYPE NULLABLE DATA DEFAULT COLUNN ID COMMENTS NULLABLE DATA DEFAULT COLUMN IDCOMMENTS 1 EMPLOYEE EMAIL 2 EMPLOYEE NAME 3SUPERVISOR VARCHAR2 (50 BYTE) No VARCHAR2 (100 BYTE) No ARCHAR2 (100 BYTE) Yes (null) (null) (null) 1 (null) 2 (null) 3 (null)