On 30 Jul 2014, at 8:51am, Clemens Ladisch <clem...@ladisch.de> wrote:
> Jonathan Moules wrote: >> Which type of average does avg() calculate? >> >> I guess it's the mean, but it could be median or mode, so worth asking. > > The SQL standard says it's the mean. Might be worth noting that avg() treats null values the same way that sum() treats nulls: it ignores them and does not include them in the divisor, unless all the values are null, in which case it returns null. This may not be what you are expecting. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users