SELECT worker.last_name AS "Tyontekija", employee_id AS "Tt#", manager.last_name AS "Manageri",
manager_id AS "Mgr#"
FROM employees worker JOIN employees manager
ON (worker.manager_id = manager.employee_id)
ORDER BY 'Tt#' ASC, 'Mgr#' ASC;