count data and sum of data

Hello Garima,

Try this one

SELECT S.Id, S.Name AS SName
    ,CASE WHEN SUM(D.Approved) IS NULL THEN 0 ELSE SUM(D.Approved) END AS Approved 
    ,CASE WHEN Sum(D.Pending) IS NULL THEN 0 ELSE SUM(D.Pending) END AS Received
    ,CASE WHEN SUM(UnderProcess) IS NULL THEN 0 ELSE SUM(Process) END AS UnderProcess
	,(CASE WHEN SUM(D.Approved) IS NULL THEN 0 ELSE SUM(D.Approved) END +
    CASE WHEN SUM(D.Pending) IS NULL THEN 0 ELSE SUM(D.Pending) END +
    CASE WHEN SUM(UnderProcess) IS NULL THEN 0 ELSE SUM(Process) END) AS TotalApplication
    FROM [dbo].[Sectors] AS S
    LEFT JOIN [dbo].[PMasters] AS A ON S.Id = A.AltSectorId
    LEFT JOIN D_AStatistics AS D ON A.Id = D.ActivityID
        GROUP BY S.Id, S.Name
        ORDER BY 1

try this code

SELECT sec.Id, Sec.Name as SName,
    CASE WHEN SUM(DAS.Approved) IS NULL THEN 0 ELSE SUM(DAS.Approved) END as Approved,
    CASE WHEN SUM(DAS.Pending) IS NULL THEN 0 ELSE SUM(DAS.Pending) END as Received,
    CASE WHEN SUM(DAS.UnderProcess) IS NULL THEN 0 ELSE SUM(DAS.UnderProcess) END as UnderProcess,
    (CASE WHEN SUM(DAS.Approved) IS NULL THEN 0 ELSE SUM(DAS.Approved) END +
    CASE WHEN SUM(DAS.Pending) IS NULL THEN 0 ELSE SUM(DAS.Pending) END +
    CASE WHEN SUM(DAS.UnderProcess) IS NULL THEN 0 ELSE SUM(DAS.UnderProcess) END) as TotalApplication
FROM [dbo].[Sectors] Sec
LEFT JOIN [dbo].[PMasters] AS A ON Sec.Id = A.AltSectorId
LEFT JOIN D_AStatistics AS DAS ON A.Id = DAS.ActivityID
GROUP BY Sec.Name, Sec.Id
ORDER BY 1;