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