SELECT YOURREQUIRED COLUMNS.............,
SUM(CASE WHEN YrsofSrvcOrgHire=0.0 THEN YrsofSrvcOrgHire ELSE 0 END) AS [<90 days],
SUM(CASE WHEN YrsofSrvcOrgHire BETWEEN 0.1 AND 0.9999 THEN YrsofSrvcOrgHire ELSE 0 END) AS [<1 year],
SUM(CASE WHEN YrsofSrvcOrgHire BETWEEN 1.0 AND 2.9999 THEN YrsofSrvcOrgHire ELSE 0 END) AS [<3 year],
SUM(CASE WHEN YrsofSrvcOrgHire>=3.0 THEN YrsofSrvcOrgHire ELSE 0 END) AS [> 3]
FROM
(SELECT DISTINCT M_COSTCENTER_6_CURR.GLSEGMENT                                   AS GL_CC,
                 M_COSTCENTER_6_CURR.ORGANIZATIONDESCRIPTION,
                 TSY_PERSON_CODES.PERSONCODE                                     AS TERMINATIONTYPE,
                 TPERSONS.LASTNAME,
                 TPERSONS.FIRSTNAME,
                 TPERSONS.MIDDLENAME,
                 TSY_PERSON_CODES_1.PERSONCODE                                   AS GENDER,
                 TETHNIC_CODES.ETHNICCODE,
                 TREASON_CODES.REASONCODE,
                 CONVERT(VARCHAR(10),TEMPLOYMENT_STATUS.ORIGINALHIREDATE,
                         101) AS ORIGHIREDT,
                 CONVERT(VARCHAR(10),TEMPLOYMENT_STATUS.TERMINATIONDATE,
                         101) AS TERMDATE,
                 DATEDIFF(Y,TEMPLOYMENT_STATUS.ORIGINALHIREDATE,TEMPLOYMENT_STATUS.TERMINATIONDATE) / 365.25 AS YRSOFSRVCORGHIRE
                 
 FROM   TEMPLOYMENT_CODES
        INNER JOIN TEMPLOYMENT_STATUS
          ON TEMPLOYMENT_CODES.EMPLOYMENTCODEIDNO = TEMPLOYMENT_STATUS.EMPLOYMENTSTATUS
        INNER JOIN TSY_PERSON_CODES
          ON TEMPLOYMENT_STATUS.TERMINATIONTYPEIDNO = TSY_PERSON_CODES.PERSONCODEIDNO
        INNER JOIN TREASON_CODES
          ON TEMPLOYMENT_STATUS.EMPLOYMENTSTATUSREASONIDNO = TREASON_CODES.REASONCODEIDNO
        INNER JOIN TPERSONS
          ON TEMPLOYMENT_STATUS.PERSONIDNO = TPERSONS.PERSONIDNO
        INNER JOIN TETHNIC_CODES
          ON TPERSONS.ETHNICCODEIDNO = TETHNIC_CODES.ETHNICCODEIDNO
        INNER JOIN TSY_PERSON_CODES AS TSY_PERSON_CODES_1
          ON TPERSONS.GENDERIDNO = TSY_PERSON_CODES_1.PERSONCODEIDNO
        INNER JOIN TPERSON_POSITIONS
          ON TEMPLOYMENT_STATUS.PERSONIDNO = TPERSON_POSITIONS.PERSONIDNO
        INNER JOIN TPOSITION_CODES
          ON TPERSON_POSITIONS.POSITIONIDNO = TPOSITION_CODES.POSITIONIDNO
        INNER JOIN M_COSTCENTER_6_CURR
          ON TPOSITION_CODES.POSITIONIDNO = M_COSTCENTER_6_CURR.POSITIONIDNO
                                            
 WHERE  (TEMPLOYMENT_STATUS.EMPLOYMENTSTATUSTOEFFECTDATE >= '3000-01-01 00:00:00.000')
        AND (TEMPLOYMENT_CODES.EMPLOYMENTCODE = 'Terminated')
        AND (TEMPLOYMENT_STATUS.TERMINATIONDATE >= CONVERT(DATETIME,'2008-12-01 00:00:00',102)))

Z
GROUP BY YOURREQUIRED COLUMNS................
ORDER BY YOURREQUIRED COLUMNS............