SELECT 
        v.Name as Shz,
        w.Name_center as W_center,
        sum(Pay_dogovor.RSumma) as RSumma
  FROM Pay_dogovor 
                   LEFT OUTER JOIN  Dogovor  ON   Dogovor.Kod_dog = Pay_dogovor.Kod_dog
                   left outer join Organization o ON o.Kod_organ = Pay_dogovor.Kod_organ 
                   left outer join A_invest_exp a on a.Id = Pay_dogovor.Id_a_invest_exp
				   inner join Tip_shz v on v.Kod_shz = Pay_dogovor.Kod_shz and v.Schet_in_bank='kassa'
				   inner join W_center w on Pay_dogovor.W_center = w.Kod_center
  WHERE Pay_dogovor.Tip_pay =  2  
		and Pay_dogovor.Kod_shz is not null
		and Pay_dogovor.Data_dokum between :Start_date and :End_date
	GROUP BY v.Name, w.Name_center
	Order By Shz, W_center