SQL Sorgu Fiili ile Alınan Sipariş Karşılaştırma

SELECT  MLZ.NAME ,
                STITOTS.STOCKREF ,
                SUM(STITOTS.RESERVED - STITOTS.SHIPPED) AS [ALINAN_ŞİPARİŞLER] ,
                SUM(STITOTS.ONHAND) AS [FİİLİ_STOK] ,
                SUM(STITOTS.ACTPORDER) AS [VERİLEN_SİPARİŞLER] ,
                ( STITOTS.ONHAND + STITOTS.ACTPORDER ) - STITOTS.RESERVED AS [FARK]
        FROM    LV_607_01_STINVTOT STITOTS WITH ( NOLOCK )
                JOIN dbo.LG_607_ITEMS AS MLZ ON MLZ.LOGICALREF = STITOTS.STOCKREF
        WHERE   ( STITOTS.INVENNO <> -1 )
                AND ( STITOTS.DATE_ > CONVERT(DATETIME, '01-01-2000', 101) )
                AND ( STITOTS.DATE_ <= CONVERT(DATETIME, GETDATE(), 101) )
                AND MLZ.CARDTYPE = 1
        GROUP BY MLZ.NAME ,
                STITOTS.STOCKREF ,
                ( STITOTS.ONHAND + STITOTS.ACTPORDER ) - STITOTS.RESERVED;