SELECT job_id FROM employees GROUP BY job_id HAVING AVG(salary) > 8000
Find the job ID for those jobs which average salary is above 8000.
SELECT job_id FROM employees GROUP BY job_id HAVING AVG ( salary ) > 8000
select job_id from employees group by job_id having avg ( salary ) > value
Find the job ID for those jobs which average salary is above 8000 .