Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
165 B
1
Indexable
Never
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;