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
job ID for jobs = job_id; average salary is above 8000 refers to HAVING AVG(salary) > 8000;