SELECT     DestAddressName, CategoryName, 'Count' = Expr3, 'NewPriority' = CASE WHEN ((CategoryName = 'High') AND ((VulnStatus = 1) OR
                      (VulnStatus = 4) OR
                      (VulnStatus = 6) OR
                      (VulnStatus = 7) OR
                      (VulnStatus = 8))) THEN 'Hyper' ELSE CategoryName END
FROM         (SELECT     TOP 4294967295 SensorData.DestAddressInt, SensorData.DestAddressName, Categories.CategoryName, 
                                              COUNT(Categories.CategoryName) AS Expr3, SensorData.VulnStatus
                       FROM          SensorData INNER JOIN
                                              Categories ON SensorData.AlertPriority = Categories.CategoryID INNER JOIN
                                              Hosts ON SensorData.DestAddressInt = Hosts.HostIPNbr INNER JOIN
                                              Groups ON Hosts.HostID = 2
                       WHERE      ((SensorData.DestAddressName IS NOT NULL) AND (Month(AlertDateTime) = Month(GetUTCDATE())))
                       GROUP BY SensorData.DestAddressInt, SensorData.DestAddressName, SensorData.AlertPriority, Categories.CategoryName, 
                                              SensorData.VulnStatus
                       ORDER BY SensorData.DestAddressInt, SensorData.DestAddressName, SensorData.AlertPriority, Categories.CategoryName, SensorData.VulnStatus) 
                      DERIVEDTBL
GROUP BY DestAddressName, CategoryName, Expr3, VulnStatus
ORDER BY DestAddressName, CategoryName, Expr3, VulnSTatus