Consider the table Employees $($id serial, name varchar$(255),$ manager id int$)$;

In this table, manager is also an employee. Assume the CEO has no manager, but every other employee has one manager.

You want to write a query that gives all managers of a given employee with id $=5.$

SELECT e$1.$id$,$ e$1.$name, e$1.$manager id FROM employees e$1$ INNER JOIN

employees e$2$ ON el$.$id $=$ e$2.$manager id AND e$2.$id $=5$

$$ WITH managerchain AS

SELECT id$,$ name, manager$\_$id FROM employees WHERE id $=5$

UNION ALL

SELECT e$.$id$,$ e$.$name, e$.$manager$\_$id FROM employees e INNER JOIN

managerchain m ON e$.$id $=$ m$.$manager$\_$id $)$

SELECT $\backslash "$ FROM managerchain;

SELECT id$,$ name, manager id FROM employees WHERE id $=5$

WITH managerchain AS

SELECT id$.$ name, manager id FROM employees