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 |