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
jobs with average salary above 8000 refers to HAVING AVG(salary) > 8000; job ids corresponding to jobs refers to SELECT job_id;