SQL Queries - CAST Central Base - Queries on grades - How to get the Health Factor grades

SELECT   dos.OBJECT_NAME               AS "Name"                 ,
         dos.OBJECT_FULL_NAME          AS "Description"          ,
         ds.SNAPSHOT_ID                AS "Snapshot"             ,
         ds.SNAPSHOT_NAME              AS "Version"              ,
         SUM(dmr.TQI)                  AS "TQI"                  ,
         SUM(dmr.Architecture)         AS "Architecture"         ,
         SUM(dmr.Changeability)        AS "Changeability"        ,
         SUM(dmr.Documentation)        AS "Documentation"        ,
         SUM(dmr.Efficiency)           AS "Efficiency"           ,
         SUM(dmr.ProgrammingPractices) AS "Programming Practices",
         SUM(dmr.Robustness)           AS "Robustness"           ,
         SUM(dmr.Security)             AS "Security"             ,
         SUM(dmr.Maintainability)      AS "SEI Maintainability"  ,
         SUM(dmr.Transferability)      AS "Transferability"
FROM     DSS_SNAPSHOTS ds
         JOIN DSS_OBJECTS dos
         ON       dos.OBJECT_ID = ds.APPLICATION_ID
         JOIN
                  (SELECT dmr.SNAPSHOT_ID,
                          dmr.OBJECT_ID  ,
                          CASE
                                  WHEN dmr.METRIC_ID = 60011
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Transferability,
                          CASE
                                  WHEN dmr.METRIC_ID = 60012
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Changeability,
                          CASE
                                  WHEN dmr.METRIC_ID = 60013
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Robustness,
                          CASE
                                  WHEN dmr.METRIC_ID = 60014
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Efficiency,
                          CASE
                                  WHEN dmr.METRIC_ID = 60015
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Maintainability,
                          CASE
                                  WHEN dmr.METRIC_ID = 60016
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Security,
                          CASE
                                  WHEN dmr.METRIC_ID = 60017
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS TQI,
                          CASE
                                  WHEN dmr.METRIC_ID = 66031
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS ProgrammingPractices,
                          CASE
                                  WHEN dmr.METRIC_ID = 66032
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Architecture,
                          CASE
                                  WHEN dmr.METRIC_ID = 66033
                                  THEN dmr.METRIC_NUM_VALUE
                                  ELSE 0
                          END AS Documentation
                  FROM    DSS_METRIC_RESULTS dmr
                  WHERE   dmr.METRIC_VALUE_INDEX = 0
                  AND     dmr.METRIC_ID IN (60011,
                                            60012,
                                            60013,
                                            60014,
                                            60015,
                                            60016,
                                            60017,
                                            66031,
                                            66032,
                                            66033)
                  )
                  dmr
         ON       dmr.SNAPSHOT_ID = ds.SNAPSHOT_ID
         AND      dmr.OBJECT_ID   = ds.APPLICATION_ID
GROUP BY dos.OBJECT_NAME     ,
         dos.OBJECT_FULL_NAME,
         ds.SNAPSHOT_ID      ,
         ds.SNAPSHOT_NAME    ,
         ds.FUNCTIONAL_DATE
ORDER BY dos.OBJECT_NAME,
         ds.FUNCTIONAL_DATE

Enter the SQL query

Enter the SQL query