select a ,
b1='D',
c1=sum(case when b='D' then c end),
b2='c' ,
c2=sum(case when b='c' then c end)
from tb
group by a