CAO - FAKTURA

Code: Alles auswählen

select
    YEAR(J.RDATUM) as Jahr,
    SUM(if(MONTH(J.RDATUM) = 1,J.NSUMME,0)) as "Jan",
    SUM(if(MONTH(J.RDATUM) = 1,J.ROHGEWINN,0)) as "rJan",
    SUM(if(MONTH(J.RDATUM) = 2,J.NSUMME,0)) as "Feb",
    SUM(if(MONTH(J.RDATUM) = 2,J.ROHGEWINN,0)) as "rFeb",
    SUM(if(MONTH(J.RDATUM) = 3,J.NSUMME,0)) as "Mrz",
    SUM(if(MONTH(J.RDATUM) = 3,J.ROHGEWINN,0)) as "rMrz",
    SUM(if(MONTH(J.RDATUM) = 4,J.NSUMME,0)) as "Apr",
    SUM(if(MONTH(J.RDATUM) = 4,J.ROHGEWINN,0)) as "rApr",
    SUM(if(MONTH(J.RDATUM) = 5,J.NSUMME,0)) as "Mai",
    SUM(if(MONTH(J.RDATUM) = 5,J.ROHGEWINN,0)) as "rMai",
    SUM(if(MONTH(J.RDATUM) = 6,J.NSUMME,0)) as "Jun",
    SUM(if(MONTH(J.RDATUM) = 6,J.ROHGEWINN,0)) as "rJun",
    SUM(if(MONTH(J.RDATUM) = 7,J.NSUMME,0)) as "Jul",
    SUM(if(MONTH(J.RDATUM) = 7,J.ROHGEWINN,0)) as "rJul",
    SUM(if(MONTH(J.RDATUM) = 8,J.NSUMME,0)) as "Aug",
    SUM(if(MONTH(J.RDATUM) = 8,J.ROHGEWINN,0)) as "rAug",
    SUM(if(MONTH(J.RDATUM) = 9,J.NSUMME,0)) as "Sep",
    SUM(if(MONTH(J.RDATUM) = 9,J.ROHGEWINN,0)) as "rSep",
    SUM(if(MONTH(J.RDATUM) =10,J.NSUMME,0)) as "Okt",
    SUM(if(MONTH(J.RDATUM) =10,J.ROHGEWINN,0)) as "rOkt",
    SUM(if(MONTH(J.RDATUM) =11,J.NSUMME,0)) as "Nov",
    SUM(if(MONTH(J.RDATUM) =11,J.ROHGEWINN,0)) as "rNov",
    SUM(if(MONTH(J.RDATUM) =12,J.NSUMME,0)) as "Dez",
    SUM(if(MONTH(J.RDATUM) =12,J.ROHGEWINN,0)) as "rDez",
    SUM(if(MONTH(J.RDATUM)<=12,J.NSUMME,0)) as "Summe",
    SUM(if(MONTH(J.RDATUM)<=12,J.ROHGEWINN,0)) as "rSumme"

from
    Journal J
where
    J.QUELLE IN (3,4)
group by
    YEAR(J.RDATUM)