SELECT job_id FROM employees GROUP BY job_id HAVING AVG(salary) > 8000
What are the job ids corresponding to jobs with average salary 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
What are the job ids corresponding to jobs with average salary above 8000 ?