Untitled

SELECT JOBS.JOB_ID,JOBS.JOB_TITLE, AVG(HR.EMPLOYEES.SALARY) AS Avg FROM HR.JOBS, HR.EMPLOYEES WHERE EMPLOYEES.JOB_ID=JOBS.JOB_ID GROUP BY JOBS.Job_title,JOBS.Job_ID;