Try:

select [Day], AVG([Value] as Avg_Value

from [MyTable]

group by [Day]

Hope this helps.