Pro exercise

Look up a table in itself

Employees point at their manager by employee id, in the same table. Attach each manager's name by looking the table up in itself — joining in the right direction — and report managers that don't exist. The CEO is their own manager.

self joins
lookups
referential integrity