Untitled
unknown
plain_text
2 years ago
165 B
9
Indexable
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;
Editor is loading...
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;