Task

Район, бюджет, орг, выставление за декабрь, централизация и подрядчики, как район
Нужно собрать район, итоги по району и ниже в том числе по бюджетам в этом районе.
сумма с ндс

/*********************************************************/

формируем сразу три куска, копируем все в эксельку, сортируем по первым трем столбцам

select offi.name,bud.name,/*org.id,*/org.small_name,sum(mot.Summa+mot.Nds) as summasnds from com_jur2021..making_out_t mot
left join com_jur_spr..offices offi on mot.id_office = offi.id
left join com_jur_spr..budget_organizations borg on mot.id_organization = borg.id_organization
left join com_jur_spr..budgets bud on borg.id_budget = bud.id
left join com_jur_spr..organizations org on mot.id_organization = org.id
where mot.id_organization not in (select id from com_jur_spr..organizations where central = 1 and id_office <> 37)
group by offi.name,bud.name,/*org.id,*/org.small_name
order by offi.name,bud.name,org.small_name

select offi.name,'-','-',sum(mot.Summa+mot.Nds) as summasnds from com_jur2021..making_out_t mot
left join com_jur_spr..offices offi on mot.id_office = offi.id
left join com_jur_spr..budget_organizations borg on mot.id_organization = borg.id_organization
left join com_jur_spr..budgets bud on borg.id_budget = bud.id
left join com_jur_spr..organizations org on mot.id_organization = org.id
where mot.id_organization not in (select id from com_jur_spr..organizations where central = 1 and id_office <> 37)
group by offi.name
order by offi.name

select offi.name,bud.name,'-',sum(mot.Summa+mot.Nds) as summasnds from com_jur2021..making_out_t mot
left join com_jur_spr..offices offi on mot.id_office = offi.id
left join com_jur_spr..budget_organizations borg on mot.id_organization = borg.id_organization
left join com_jur_spr..budgets bud on borg.id_budget = bud.id
left join com_jur_spr..organizations org on mot.id_organization = org.id
where mot.id_organization not in (select id from com_jur_spr..organizations where central = 1 and id_office <> 37)
group by offi.name,bud.name
order by offi.name,bud.name