select
year, avg(amt)
from
( select
year, month, avg(t) as amt
from
temperatures
where
daynumber < currentday
group by
year, month )
group by year
Quote selectie
( 177)
( 140)