SELECT INSTRUCTOR.GIVEN_NAME, INSTRUCTOR.FAMILY_NAME, INSTRUCTOR.DEPARTMENT
  FROM INSTRUCTOR
  WHERE INSTRUCTOR.SALARY > ALL(
   SELECT AVG(INSTRUCTOR.SALARY)
    FROM INSTRUCTOR
    GROUP BY INSTRUCTOR.DEPARTMENT)


I have an instructor who has a salary OF 42000, AND the
average FOR his department IS 40500, but he's not showing up
in my answer list