SELECT last_name AS ename,
       salary,
       department_id AS deptno,
       (SELECT round(avg(salary), 2) AS avg_salary
        FROM employees e_inner
        WHERE e_inner.department_id = e_outer.department_id) AS dept_avg
FROM employees e_outer
WHERE salary > (SELECT round(avg(salary), 2) AS avg_salary
                FROM employees e_inner
                WHERE e_inner.department_id = e_outer.department_id)
ORDER BY dept_avg, deptno, last_name;