select avg(a.ritten), a.weather
from (
	select count(fRit.Id) as ritten, dimRain.weatherCondition as weather
    from fact_rit fRit, dim_rain dimRain
	where fRit.rainId=dimRain.rainId
    ) as a
GROUP BY a.ritten, a.weather;