Jan-2105    4
Feb-2015    5
Mar-2015    7

SELECT DISTINCT T1.PROJECT_NAME,
       CONCAT(CONCAT(
       CASE MONTH(T2.VAL)
       WHEN 1 THEN 'Jan' 
       WHEN 2 THEN 'Feb'
       WHEN 3 THEN 'Mar'
       WHEN 4 THEN 'Apr'
       WHEN 5 THEN 'May'
       WHEN 6 THEN 'Jun'
       WHEN 7 THEN 'Jul'
       WHEN 8 THEN 'Aug'
       WHEN 9 THEN 'Sep'
       WHEN 10 THEN 'Oct'
       WHEN 11 THEN 'Nov'
       WHEN 12 THEN 'Dec'
       END
        ,' - '),YEAR(T2.VAL)),
       COUNT( DISTINCT T1.REFERENCE_ID) AS REFERENCE_ID1,
       COUNT(DISTINCT CASE WHEN T3.VAL >= 10  THEN T3.REQUEST_ID END ) AS VAL2,
       CAST(COUNT(DISTINCT CASE WHEN T3.VAL >= 10  THEN T3.REQUEST_ID END ) AS DECIMAL) / CAST(COUNT( DISTINCT T3.REQUEST_ID) AS DECIMAL) AS VAL1
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RICALM.VW_RQST_TIMESTAMP_EXT T2
ON T2.REQUEST_ID=T1.REQUEST_ID AND T2.NAME='RequestedDate'
  LEFT OUTER JOIN RICALM.VW_RQST_INT_EXT T3
  ON T3.REQUEST_ID=T1.REQUEST_ID AND T3.NAME='com.ibm.workitem.attribute.LateContent'
WHERE T1.PROJECT_ID = 108  AND(   T1.REQUEST_TYPE = 'RCN' ) AND
(T1.ISSOFTDELETED = 0) AND 
(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)GROUP BY T1.PROJECT_NAME, T2.VAL