I'm not sure what the ISO / ANSI standard for STDDEV is exactly, only finding references here https://www.oreilly.com/library/view/sql-in-a/9780596155322/ch04s02.html If Sqlite follows Postgresql,(https://www.postgresql.org/docs/9.1/functions-aggregate.html), it means my demand STDDEV demand shall be: VARIANCE_SAMP VARIANCE_POP STDDEV_SAMP STDDEV_POP VARIANCE = alias for VARIANCE_SAMP STDDEV = alias STDDEV_SAMP