Select R.idR, R.,NazwaRozgrywek, Count(Distinct Z.idZ)/Count(Distinct M.idM) as iloscZdarzen,  (	Select count(Distinct TZ.idTZ)/Count(Distinct M.idM) as IloscBramek
																									FROM Rozgrywka as R left join SezonRozgrywek as SR ON R.idR = SR.idR
																										left join Klub as K ON SR.idK = K.idK
																										left join Mecz as M ON M.idK = K.idK AND K.idK = M.idK2
																										left join Zdarzenie as Z ON M.idM = Z.idM
																										left join TypZdarzenia as TZ ON TZ.idTz = Z.idTZ
																									Group by M.idM
																									Having Tz.nazwaTz = 'Gol gosp') golGosp

																									(	Select count(Distinct TZ.idTZ)/Count(Distinct M.idM) as IloscBramek
																									FROM Rozgrywka as R left join SezonRozgrywek as SR ON R.idR = SR.idR
																										left join Klub as K ON SR.idK = K.idK
																										left join Mecz as M ON M.idK = K.idK AND K.idK = M.idK2
																										left join Zdarzenie as Z ON M.idM = Z.idM
																										left join TypZdarzenia as TZ ON TZ.idTz = Z.idTZ
																									Group by M.idM
																									Having Tz.nazwaTz = 'Gol gosc') golGosc


FROM Rozgrywka as R left join SezonRozgrywek as SR ON R.idR = SR.idR
					left join Klub as K ON SR.idK = K.idK
					left join Mecz as M ON M.idK = K.idK AND K.idK = M.idK2
					left join Zdarzenie as Z ON M.idM = Z.idM
					left join TypZdarzenia as TZ ON TZ.idTz = Z.idTZ