(Solved) : Generate List Employees Last Name First Name Supervisors Last Name First Name Supervisor A Q43978324 . . .
Generate a list of employees (last name and first name) andtheir supervisors (last name and first name of supervisor aliasedto ReportsToLastName and ReportsToFirstName).
(Hint: When joining a table to itself, you must use tablealiases.)
— Show your answers both in self-join as wellas recursive CTE. CREATE a self-join and recursiveCTE for the above query.
Expert Answer
Answer to Generate a list of employees (last name and first name) and their supervisors (last name and first name of supervisor al…
OR