Query to Get Month Wise Hired Employees Head Count in Core HR

  SELECT TO_CHAR (ORIGINAL_DATE_OF_HIRE, 'MON') MM
       , COUNT (PERSON_ID) TOTAL
    FROM per_people_x
   WHERE TO_CHAR (ORIGINAL_DATE_OF_HIRE, 'RRRR') = '2018'
GROUP BY TO_CHAR (ORIGINAL_DATE_OF_HIRE, 'MON')