Statistics metadata in TAP

Mark Taylor M.B.Taylor at bristol.ac.uk
Fri Oct 21 09:15:37 CEST 2016


On Thu, 20 Oct 2016, Walter Landry wrote:

> As a side point, I am a little worried about what it means to take the
> mean of a table with NULL's.  I can define it, but I do not know if I
> like it.

Seems pretty straightforward and unobjectionable to me: sum the
non-null values and divide by the number of non-null values.
I presume that's what ADQL/SQL AVG does.

--
Mark Taylor   Astronomical Programmer   Physics, Bristol University, UK
m.b.taylor at bris.ac.uk +44-117-9288776  http://www.star.bris.ac.uk/~mbt/


More information about the dal mailing list