with t as
(
select  appl_month as month
    , (sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-10' then app_PS_2mob end) 
 / sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-10' then cash_to_client end))
 / cast((sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-10' then app_PS_1mob end) 
 / sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-10' then cash_to_client end))as float) as Roi1

    , (sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-11' then app_PS_2mob end) 
 / sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-11' then cash_to_client end))
 / cast((sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-11' then app_PS_1mob end) 
 / sum(case when financed = 1 and term_day <= 35 and appl_month = '2020-11' then cash_to_client end)) as float) as Roi2
  from DWH.RMT
			where		1=1						                                         
		and loyal_client = 0						
		and request_id_PDL_step1 is not null						
		and isnull(refinancing, 0) <> 1						
	    and appl_registr_method not in ('МП Android', 'МП iOS', 'Онлайн', 'Сайт ДС 2.0')						
		and office_group not in ('401' , '402',' 403', '404')
	    and date_time >= '10-01-2020'
		and date_time <='11-30-2020'
group by appl_month
order by appl_month
)
select
 t.*, avg(isnull(t.Roi1, 0) + isnull(t.Roi2, 0)) over ()
from
 t;