4.Having Clause - SQL Code(open)

-- having Clause

selectjobtitle, count(jobtitle)
from[SQL Tutorial].dbo.EmployeeDemographics a
join [SQL Tutorial].dbo.EmployeeSalary b
	ona.EmployeeID =b.EmployeeID
group byJobTitle
having COUNT(jobtitle) >1


selectjobtitle, Avg(Salary)
from[SQL Tutorial].dbo.EmployeeDemographics a
join [SQL Tutorial].dbo.EmployeeSalary b
	ona.EmployeeID =b.EmployeeID
group byJobTitle
having avg(Salary) >1-- right after the group by and before the order by
orderbyAVG(salary)