SQL Sorgu Yıllara Göre Banka Borç Alacak Bakiyesi

select DATEPART(YEAR, "DT_BNFLINE"."DATE_") AS "YIL",
SUM("DT_BNFLINE"."ALACAK") AS "ALACAK",
SUM("DT_BNFLINE"."BORC") AS "BORC",
SUM("DT_BNFLINE"."BAKIYE") AS "BAKIYE",
    DEFINITION_ AS "BANKA_ADI"
FROM (SELECT BNFLINE.*,
CASE BNFLINE.SIGN WHEN 0 THEN
(CASE BNFLINE.TRCURR WHEN 0 THEN BNFLINE.AMOUNT ELSE BNFLINE.TRNET END) ELSE 0 END AS "BORC",
(CASE BNFLINE.SIGN WHEN 1 THEN (CASE BNFLINE.TRCURR WHEN 0 THEN BNFLINE.AMOUNT ELSE BNFLINE.TRNET END)
ELSE 0 END) AS "ALACAK",
(CASE BNFLINE.SIGN WHEN 1 THEN
(CASE BNFLINE.TRCURR WHEN 0 THEN BNFLINE.AMOUNT
ELSE BNFLINE.TRNET END)*-1
ELSE
(CASE BNFLINE.TRCURR WHEN 0 THEN
BNFLINE.AMOUNT ELSE BNFLINE.TRNET END) END )AS "BAKIYE",
(CASE BNFLINE.TRCURR WHEN 0 THEN 'TL'
ELSE L_CURRENCYLIST.CURCODE END) AS "DOVIZ_TURU"
FROM LG_607_01_BNFLINE BNFLINE WITH(NOLOCK)
LEFT JOIN [HUBERDB].[dbo].L_CURRENCYLIST L_CURRENCYLIST (NOLOCK)
ON L_CURRENCYLIST.CURTYPE=BNFLINE.TRCURR AND L_CURRENCYLIST.FIRMNR='607'
WHERE CANCELLED=0) "DT_BNFLINE"
LEFT OUTER JOIN "dbo"."LG_607_BNCARD" "dbo_LG_607_BNCARD" ON
("DT_BNFLINE"."BANKREF" = "dbo_LG_607_BNCARD"."LOGICALREF")
GROUP BY DATEPART(year, "DT_BNFLINE"."DATE_"), "dbo_LG_607_BNCARD"."DEFINITION_"
ORDER BY "YIL", "BANKA_ADI"