[SQL] Having clause with Group By and Where

SELECT DEPARTMENTNAME, SUM(SALARY)
FROM DBO.EMPLOYEE
GROUP BY DEPARTMENTNAME
HAVING SUM(SALARY) > 100000
ORDER BY SUM(SALARY) DESC




SELECT DEPARTMENTNAME, SUM(SALARY)
FROM DBO.EMPLOYEE
WHERE DEPARTMENTNAME ='HR'
GROUP BY DEPARTMENTNAME



OR

SELECT DEPARTMENTNAME, SUM(SALARY)
FROM DBO.EMPLOYEE
GROUP BY DEPARTMENTNAME
HAVING DEPARTMENTNAME='HR'



- WHERE CLAUSE AND HAVING TOGETHERE:

SELECT DEPARTMENTNAME,S UM(SALARY)
FROM DBO.EMPLOYEE
WHERE GENDER ='M'
GROUP BY DEPARTMENTNAME
HAVING SUM(SALARY) > 50000
ORDER BY SUM(SALARY) DESC