Paige is leaving

Problem

Paige, employee 3, is leaving the company. Before her row gets deleted, her people need somewhere to go: whoever reports to her today will report to whoever Paige reports to. Nobody is left without a boss, and nobody is left pointing to someone who's gone.

Her people are the ones who have her as their boss, whatever department they're in. And don't type in Paige's boss by hand: the change has to work just as well on the day she reports to someone else.

Write the handoff and the delete. It's graded by looking at who the boss is for each person still at the company.

What it has to return

SELECT id, name, boss_id FROM employees;

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

DELETE FROM employees
WHERE id = 3;