SELECT E.FIRST_NAME, E.LAST_NAME, D.DEPARTMENT_NAME, J.JOB_TITLE, E.SALARY, 0.8 * J.MAX_SALARY AS "80% MAX_SALARY"
FROM EMPLOYEES E
JOIN DEPARTMENTS D ON D.DEPARTMENT_ID = E.DEPARTMENT_ID
JOIN JOBS J ON J.JOB_ID = E.JOB_ID
WHERE E.DEPARTMENT_ID IN (
    SELECT E.DEPARTMENT_ID
    FROM EMPLOYEES E
    GROUP BY E.DEPARTMENT_ID
    HAVING COUNT(*) > 2
)
AND E.SALARY > 0.8 * J.MAX_SALARY
ORDER BY D.DEPARTMENT_NAME;