Nulls in avg and count

select     

    sum(a) / count(a)  [homemade average - count doesnt count nulls],

      avg(isnull(a,0))  [average with isnull],

      avg(a)  [regular average]

from

(

select null a

union select 0

union select 5

union select 15

) main