SQL & PL/SQL

Greetings all,

I am having a nightmare getting this query to run in Oracle SQL Developer.

REM (HIGHEST EARNING EMPLOYEE in each LOCATION excluding MANAGERS/SALESPEOPLE/PRESIDENT)


CREATE OR REPLACE VIEW HIGHEST_EARNER_PER_LOCATION
AS
   SELECT EMPLOYEE_NAME, L.REGIONAL_GROUP AS REGIONAL_GROUP, E.SALARY AS SALARY, J.JOB_ID AS JOB_ID
     FROM (  SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME,
                    L.REGIONAL_GROUP REGIONAL_GROUP
               FROM EMPLOYEE E
                    LEFT OUTER JOIN DEPARTMENT D
                       ON D.DEPARTMENT_ID = E.DEPARTMENT_ID
                    LEFT OUTER JOIN LOCATION L 
                       ON L.LOCATION_ID = D.LOCATION_ID
                    LEFT OUTER JOIN JOB J 
                       ON J.JOB_ID = E.JOB_ID
           GROUP BY E.FIRST_NAME || ' ' || E.LAST_NAME)
    WHERE JOB_ID != '670' AND JOB_ID != '671' AND JOB_ID != '672'
;
SELECT
  EMPLOYEE_NAME,
  REGIONAL_GROUP,
  SALARY
FROM
  HIGHEST_EARNER_PER_LOCATION
ORDER BY REGIONAL_GROUP DESC
;

It just keeps throwing the error:

Error at Command Line:17 Column:50
Error report:
SQL Error: ORA-00904: "JOB_ID": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:

Any suggestions would be greatly appreciated..

Thanks in advance.