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