---

select
    cast(o.ef_year as varchar(4)) as year_name,
    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 o.ef_year, ot.name
order by o.ef_year, ot.name;