select for voip

SELECT
    SUM(CASE WHEN HasAnswered = 'true' AND  CallingCampaign='C_DataLimit100' THEN 1 ELSE 0 END ) AS AnsweredTheCallFor100,
    SUM(CASE WHEN HasAnswered = 'true' AND  CallingCampaign='C_DataLimit80' THEN 1 ELSE 0 END ) AS AnsweredTheCallFor80,
    SUM(CASE WHEN HasAnswered = 'false' THEN 1 ELSE 0 END ) AS NotAnsweredTheCall,
    SUM(CASE WHEN Accepted = 'true' AND  CallingCampaign='C_DataLimit80' THEN 1 ELSE 0 END ) AS NotificationLimit80,
    SUM(CASE WHEN Accepted = 'true' AND  CallingCampaign='C_DataLimit100' THEN 1 ELSE 0 END ) AS NotificationLimit100,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='true' AND CallingCampaign='C_DataLimit80' THEN 1 ELSE 0 END ) AS Accepted80,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='false' AND CallingCampaign='C_DataLimit80' THEN 1 ELSE 0 END ) AS Rejected80,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='true' AND CallingCampaign='C_DataLimit100' THEN 1 ELSE 0 END ) AS Accepted100,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='false' AND CallingCampaign='C_DataLimit100' THEN 1 ELSE 0 END ) AS Rejected100,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='true' AND CallingCampaign='C_DataLimit100' AND State='Processed' THEN 1 ELSE 0 END ) AS Processed100,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='true' AND CallingCampaign='C_DataLimit80' AND State='Processed' THEN 1 ELSE 0 END ) AS Processed80,
    SUM(CASE WHEN HasAnswered = 'true' AND Confirmed='true' AND CallingCampaign='C_DataLimit80' AND State!='Processed'AND State  IS NOT NULL THEN 1 ELSE 0 END ) AS FailedActivations,

    COUNT(Id)AS Total
FROM MtelAPPs..PcrfVoipRecords (nolock)
WHERE DATEDIFF(DAY,MtelAPPs..PcrfVoipRecords.AddedOn ,GETDATE())=1