---

select
    ot.name,
    sum(o.value) as sum_value
from operations o
join back_office.operation_type ot
    on ot.id = o.operation_type_id
where o.cred_mnemonics like '%ИД%'
  and o.operation_type_id <> 106
group by ot.name
order by ot.name;