Sql Query To Use a ' SELECT ' statement with HAVING Clause

SELECT 'Retrieve the number of employees in each department,whose department has employee greater than 5'; SELECT COUNT(employee_id) FROM employees GROUP BY department_id HAVING COUNT(employee_id)>5; SELECT 'Find the maximum salary of the employee in each department, whose department maximum salary is greater than 8000'; SELECT MAX(salary) FROM employees GROUP BY department_id HAVING MAX(salary)>8000; SELECT 'Find the minimum salary of the employee in each department, whose department minimum salary is greater than 8000'; SELECT MIN(salary) FROM employees GROUP BY department_id HAVING MIN(salary)>8000; SELECT 'Calculate the average salary of the employee in each department. whose department average salary is less than 8000'; SELECT AVG(salary) FROM employees GROUP BY department_id HAVING AVG(salary)<8000; SELECT 'Calculate the sum of the salary of the employee in each department. whose department salary sum is less than 20000'; SELECT SUM(salary) FROM employees GROUP BY department_id HAVING SUM(salary)<20000;