SELECT substr(p.lastname||', '||p.firstname,1,25) "Employee",
       e.supervisor_id "Super. ID",
       s.title "Super. Title"
  FROM employee e JOIN person p USING (id)
                  LEFT OUTER JOIN employee s ON s.id = e.supervisor_id
 ORDER BY "Super. ID", "Employee"
/
