na dann,

select kdnr, sum(Umsatz) as Summe
from ...
group by kdnr