SQL Query - Get MINUS Count from Query

Try This Another Way

SELECT
    t.Location AS 'Stock Location',
    t.CertifiedBy AS 'Stock Owner',
    CAST(t.CertifiedOn AS date) AS 'Date: DD/MMM/YYYY HH:MM',
    t.CertifiedStock AS 'Certified Stock',
    t.TotalStock - t.CertifiedStock AS 'Pending'
FROM
    (
    SELECT
        stockcerti.Location,
        stockcerti.CertifiedBy,
        CAST(stockcerti.CertifiedOn AS date) AS CertifiedOn,
        COUNT(*) AS CertifiedStock,
        (
            SELECT COUNT(*)
            FROM tblMasterEntry lotmasterentry
            LEFT OUTER JOIN tbLocOwnerMap locown ON locown.AssetLocId = lotmasterentry.varLocationId
                AND locown.AssetLoc = lotmasterentry.varLocation
                AND lotmasterentry.charSt = 'N'
            WHERE lotmasterentry.varLocation = stockcerti.Location
                AND locown.AssetCSO = stockcerti.CertifiedBy
                AND lotmasterentry.varLocation IS NOT NULL
        ) AS TotalStock
    FROM
        tbl_StockOwner_AssetCertification stockcerti
    WHERE
        stockcerti.CertifiedBy = 'Prasannakumar.Merugu'
    GROUP BY
        stockcerti.Location,
        stockcerti.CertifiedBy,
        CAST(stockcerti.CertifiedOn AS date)
    ) AS t

Hello Riddhi Valecha,

Try Following Query,

SELECT
    stockcerti.Location AS 'Stock Location',
    stockcerti.CertifiedBy AS 'Stock Owner',
    CAST(stockcerti.CertifiedOn AS date) AS 'Date: DD/MMM/YYYY HH:MM',
    COUNT(*) AS 'Certified Stock',
    (
        SELECT COUNT(*)
        FROM tblMasterEntry lotmasterentry
        LEFT OUTER JOIN tbLocOwnerMap locown ON locown.AssetLocId = lotmasterentry.varLocationId
            AND locown.AssetLoc = lotmasterentry.varLocation
            AND lotmasterentry.charSt = 'N'
        WHERE lotmasterentry.varLocation = stockcerti.Location
            AND locown.AssetCSO = stockcerti.CertifiedBy
            AND lotmasterentry.varLocation IS NOT NULL
    ) AS 'TotalStock',
    (
        (
            SELECT COUNT(*)
            FROM tblMasterEntry lotmasterentry
            LEFT OUTER JOIN tbLocOwnerMap locown ON locown.AssetLocId = lotmasterentry.varLocationId
                AND locown.AssetLoc = lotmasterentry.varLocation
                AND lotmasterentry.charSt = 'N'
            WHERE lotmasterentry.varLocation = stockcerti.Location
                AND locown.AssetCSO = stockcerti.CertifiedBy
                AND lotmasterentry.varLocation IS NOT NULL
        )
        -
        COUNT(*)
    ) AS 'Pending'
FROM tbl_StockOwner_AssetCertification stockcerti
WHERE stockcerti.CertifiedBy = 'Prasannakumar.Merugu'
GROUP BY stockcerti.Location, stockcerti.CertifiedBy, CAST(stockcerti.CertifiedOn AS date)