/*34. Write a query in SQL to display the job ID for those jobs which average salary is above 8000.*/
SELECT job_id, AVG(salary)   
     FROM employees   
         GROUP BY job_id   
               HAVING AVG(salary)>8000; 