The employees table contains a list of employees of a


The employees table contains a list of employees of a company. An employee may be managed by another employee. To denote an employee's manager, the employee_id of the manager is entered into the manager_id field of the employee reporting to that manager. In order to produce a list of which managers supervise which employees, the table may be joined to itself using these two attributes (employee_id, manager_id). This is known as a SELF-JOIN. Use a SELF-JOIN on the employees table to produce a result containing two columns: the concatenated last_name and first_name of the manager, and the concatenated last_name and first_name of the employee. Label the first-column supervisor, and the second-column employee. Order the output by the supervisor's last_name and first_name.

 

 

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: The employees table contains a list of employees of a
Reference No:- TGS02651661

Now Priced at $10 (50% Discount)

Recommended (99%)

Rated (4.3/5)