Yardım SQL mizan iki tarih arası

SELECT * FROM
(SELECT
*
FROM
(
SELECT
    H.ACTIVE,
    H.HESAP_KODU,
    CASE WHEN 0  IN (0) THEN H.HESAP_ADI ELSE H.EXTNAME END HESAP_ADI,   
    H.SEVIYE,
    H.SPECODE,
    H.CYPHCODE,
    SUM(ISNULL(L.DEBIT,0)) AS [BORC],
    SUM(ISNULL(L.CREDIT,0))AS [ALACAK],
    SUM(CASE WHEN ISNULL(L.BAKIYE,0)>0 THEN ABS(ISNULL(L.BAKIYE,0)) ELSE 0 END) BORC_BAKIYE,
    SUM(CASE WHEN ISNULL(L.BAKIYE,0)<0 THEN ABS(ISNULL(L.BAKIYE,0)) ELSE 0 END) ALACAK_BAKIYE,
    SUM(ISNULL(L.BAKIYE,0)) "BAKIYE",
    SUM(ISNULL(L.RD_BORC,0)) AS "RD_BORC",
    SUM(ISNULL(L.RD_ALACAK,0)) AS "RD_ALACAK",
    SUM(ISNULL(L.RD_BORC,0)-ISNULL(L.RD_ALACAK,0)) AS "RD_BAKIYE"
FROM
(
SELECT
    H.ACTIVE,
    H.CODE AS [HESAP_KODU],
    H.DEFINITION_ AS [HESAP_ADI],
    H.EXTNAME,
    H.SPECODE,
    H.CYPHCODE,
    CASE LEN(CODE) WHEN 1 THEN -2 WHEN 2 THEN -1 ELSE
    LEN(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(H.CODE,'0',''),'1',''),'2',''),'3',''),'4',''),'5',''),'6',''),'7',''),'8',''),'9','')) END AS [SEVIYE]
FROM
    LG_019_EMUHACC H WITH(NOLOCK)
)H
    LEFT OUTER JOIN
(
SELECT
L.ACCOUNTCODE,
SUM(ROUND(L.DEBIT,6)) DEBIT,
SUM(ROUND(L.CREDIT,6)) CREDIT,
ROUND(SUM(ROUND(L.DEBIT,6)-ROUND(L.CREDIT,6)),6) BAKIYE, 
SUM((1-L.SIGN)*ROUND(L.REPORTNET,6)) RD_BORC,
SUM(L.SIGN*ROUND(L.REPORTNET,6)) RD_ALACAK,
SUM((1-L.SIGN)*ROUND(L.AMNT,6)) B_MIKTAR,
SUM(L.SIGN*ROUND(L.AMNT,6)) A_MIKTAR
FROM
LG_019_01_EMFLINE L
 WHERE
L.DATE_ BETWEEN CONVERT(dateTime, '1-1-2006', 101) AND CONVERT(dateTime, '12-31-2020', 101)
AND L.TRCODE IN (1,2,3,4,6,7)
AND L.CANCELLED = 0

GROUP BY
L.ACCOUNTCODE
)L
    ON H.HESAP_KODU=SUBSTRING(L.ACCOUNTCODE,1,LEN(H.HESAP_KODU))
GROUP BY
    H.ACTIVE,
    H.HESAP_KODU,
    H.HESAP_ADI,
    H.EXTNAME,   
    H.SEVIYE,
    H.SPECODE,
    H.CYPHCODE
)TMP   
) AS DYNMQRY
ORDER BY DYNMQRY.[ACTIVE] ASC, DYNMQRY.[HESAP_KODU] ASC

go