Task

--Для Реброва: Собрать информацию по 303 коду - район, нас. пункт, бюджет, организация, объект, адрес объекта, месяц подключения, инв номер котельной, наименование котельной с указанием объемов и сумм по услуге "отопление"

select reg.name as 'Регион', cit.name as 'Населенный пункт', org.small_name as 'Организация', bud.name as 'Бюджет', co.number as 'Договор', co.name as 'Объект', co.address as 'Адрес объекта',
boil.inventory_number as 'Номер котельной', boil.name as 'Наименование котельной', min(cheat.month) as 'С какого месяца', sum(cheat.gcal) as 'Объем', sum(cheat.summa) as 'cумма', sum(cheat.nds) as 'ндс' from com_jur_calc..contract_objects co

left join com_jur_spr..regions reg on co.id_region = reg.id
left join com_jur_spr..cities cit on co.id_city = cit.id
left join com_jur_calc..contracts ctr on co.number = ctr.number
left join com_jur_spr..organizations org on ctr.id_organization = org.id
left join com_jur_spr..budgets bud on ctr.id_budget = bud.id
left join com_jur_spr..boilers boil on co.id_boiler = boil.id

inner join com_jur_calc..calculation_heating cheat on co.number = cheat.number and co.id = cheat.id_object
where co.number in (select number from com_jur_calc..contracts where year = 2021 and dead = 0 and number not like '37%') and co.code = 303

group by reg.name, cit.name, org.small_name, bud.name, co.number, co.name, co.address,boil.inventory_number, boil.name
order by co.number