select 'Входящие' as message,do_st,
sum(case when DO_KODV=840 then 1 else 0 end) as usd_kol,
sum(case when DO_KODV=978 then 1 else 0 end) as eur_kol,
sum(case when DO_KODV=398 then 1 else 0 end) as kzt_kol,
sum(case when DO_KODV=826 then 1 else 0 end) as gbp_kol,
sum(case when DO_KODV=392 then 1 else 0 end) as jpy_kol,
sum(case when DO_KODV=643 then 1 else 0 end) as rub_kol
from dokod as d inner join sprstr as s
on d.DO_ST=s.s_kod
where do_date between '20180301' and '20180401'
and (do_lc1 like '127101022%' or do_lc1 like '127101023%' or do_lc1 like '127101024%' 
  or do_lc1 like '127101025%' or do_lc1 like '127101026%' or do_lc1 like '127101029%')
and substring(do_lc2,4,5)<>'60303' and do_kodv<>'417'
group by DO_ST

select 'Входящие' as message,do_st,
sum(case when DO_KODV=840 then 1 else 0 end) as usd_kol,
sum(case when DO_KODV=978 then 1 else 0 end) as eur_kol,
sum(case when DO_KODV=398 then 1 else 0 end) as kzt_kol,
sum(case when DO_KODV=826 then 1 else 0 end) as gbp_kol,
sum(case when DO_KODV=392 then 1 else 0 end) as jpy_kol,
sum(case when DO_KODV=643 then 1 else 0 end) as rub_kol

sum(case when DO_KODV=840 then qty else 0 end) as usd_sum,
...