for this SQL Statement:

SELECT
         "TIME_PROPERTIES für USER"."USR_NAME.NAME",

          "TIME_PROPERTIES für USER"."TIME_PROPERTIES.Date",
         sum (case when "TIME_PROPERTIES für USER"."TIME_PROPERTIES.Date" = '2019' then "TIME_PROPERTIES für USER"."TIME_PROPERTIES.QTY" else 0 end) as "Summe 2019",
         sum (case when "TIME_PROPERTIES für USER"."TIME_PROPERTIES.Date" = '2020' then "TIME_PROPERTIES für USER"."TIME_PROPERTIES.QTY" else 0 end) as "Summe 2020"
FROM  "TIME_PROPERTIES für USER"
WHERE     "TIME_PROPERTIES für USER"."USR_NAME.NAME"  like '%DUS%'
GROUP BY  "TIME_PROPERTIES für USER"."USR_NAME.NAME"

I receive the failure:

That my group by statement is wrong, this could be possible because there is "TIME_PROPERTIES für USER"."TIME_PROPERTIES.Date" loaded with 2019 and 2020 as value. But when I delead it I get a failure for the sum arguments.

Is there some expert could take a look to my statement up, and give me a tip to solve it - because in the moment I´m lost ?)

My table strukture for the original table where the colums from:

Name      Qty      Date

Lars      10      2019

Lars      11      2020

Lars      9      2019

Peter      8      2020

Peter      7      2020

Peter      10      2020

etc...

Thanks

Lars