By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| employee | title | division | employee | ||
|---|---|---|---|---|---|
| Boss Person | boss | o | bp@email | null | null |
| John Smith | supervisor | a | jos@email | Boss Person | bp@email |
| Jane Smith | supervisor | b | jas@email | Boss Person | bp@email |
| Leo Messi | employee | a | lm@email | John Smith | jos@email |
| Amanda Kessel | employee | a | ak@email | John Smith | jos@email |
| Derek Jeter | employee | b | dj@email | Jane Smith | jas@email |