Example:
  Objective: In this example, we will count the number of employees in each department where the count is greater than             10 .
           SELECT Department , COUNT(Ecode) as [TotalCount] FROM Tbl_Emp
                            GROUP BY Department                                                                                     HAVING COUNT(Ecode)>10
                                ORDER BY Department;
  Output: