SQL Sorgu Grup Bazlı Satışlar

SELECT SNM.URUNKODU,SNM.URUNADI,SUM(SNM.TOPLAM)TOPLAMSATIS,
    SUM(SNM.OCASATIS)OCAKSATIS, SUM(SNM.SUBSATIS)SUBATSATIS,
    SUM(SNM.MARSATIS)MARTSATIS, SUM(SNM.NISSATIS)NISANSATIS,
    SUM(SNM.MAYSATIS)MAYISSATIS, SUM(SNM.HAZSATIS)HAZIRANSATIS,
    SUM(SNM.TEMSATIS)TEMMUZSATIS, SUM(SNM.AGUSATIS)AGUSTOSSATIS,
    SUM(SNM.EYLSATIS)EYLULSATIS, SUM(SNM.EKISATIS)EKIMSATIS,
    SUM(SNM.KASSATIS)KASIMSATIS, SUM(SNM.ARASATIS)ARALIKSATIS
FROM(SELECT(SELECT SPECODE2 FROM LG_115_ITEMS WHERE LOGICALREF=S.STOCKREF) AS URUNKODU,
(SELECT DEFINITION_ FROM LG_115_SPECODES WHERE SPECODETYPE=1 AND SPETYP2=1 AND SPECODE=
(SELECT SPECODE2 FROM LG_115_ITEMS WHERE LOGICALREF=S.STOCKREF))AS URUNADI,
    ISNULL(SUM(S.VATMATRAH),0) AS TOPLAM, ISNULL(SUM(S.AMOUNT),0) AS MIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=1 THEN SUM(S.VATMATRAH) END,0) AS OCASATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=1 THEN SUM(S.AMOUNT) END,0) AS OCAMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=2 THEN SUM(S.VATMATRAH) END,0) AS SUBSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=2 THEN SUM(S.AMOUNT) END,0) AS SUBMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=3 THEN SUM(S.VATMATRAH) END,0) AS MARSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=3 THEN SUM(S.AMOUNT) END,0) AS MARMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=4 THEN SUM(S.VATMATRAH) END,0) AS NISSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=4 THEN SUM(S.AMOUNT) END,0) AS NISMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=5 THEN SUM(S.VATMATRAH) END,0) AS MAYSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=5 THEN SUM(S.AMOUNT) END,0) AS MAYMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=6 THEN SUM(S.VATMATRAH) END,0) AS HAZSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=6 THEN SUM(S.AMOUNT) END,0) AS HAZMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=7 THEN SUM(S.VATMATRAH) END,0) AS TEMSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=7 THEN SUM(S.AMOUNT) END,0) AS TEMMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=8 THEN SUM(S.VATMATRAH) END,0) AS AGUSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=8 THEN SUM(S.AMOUNT) END,0) AS AGUMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=9 THEN SUM(S.VATMATRAH) END,0) AS EYLSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=9 THEN SUM(S.AMOUNT) END,0) AS EYLMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=10 THEN SUM(S.VATMATRAH) END,0) AS EKISATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=10 THEN SUM(S.AMOUNT) END,0) AS EKIMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=11 THEN SUM(S.VATMATRAH) END,0) AS KASSATIS,
    ISNULL(CASE WHEN MONTH(S.DATE_)=11 THEN SUM(S.AMOUNT) END,0) AS KASMIKTAR,
    ISNULL(CASE WHEN MONTH(S.DATE_)=12 THEN SUM(S.VATMATRAH) END,0) AS ARASATIS,
ISNULL(CASE WHEN MONTH(S.DATE_)=12 THEN SUM(S.AMOUNT) END,0) AS ARAMIKTAR
from LG_115_01_STLINE S
WHERE S.INVOICEREF>0 AND S.CANCELLED=0 AND S.TRCODE IN(1)
AND S.STOCKREF IN(SELECT LOGICALREF FROM LG_115_ITEMS WHERE SPECODE2
IN(SELECT SPECODE FROM LG_115_SPECODES WHERE SPECODETYPE=1 AND SPETYP2=1))
GROUP BY S.STOCKREF, MONTH(S.DATE_)) AS SNM
GROUP BY SNM.URUNKODU,SNM.URUNADI
ORDER BY SNM.URUNKODU