# sqlite has no function like std or var. This is a method of how it can be calculated
# assume we want to get the variance of the column fieldRA from the table Summary in a sqlite DB. In this case the following produces the variance
SELECT avg((SUMMARY.fieldRA - sub.a)*(SUMMARY.fieldRA - sub.a)) FROM Summary, (SELECT avg(fieldRA) as a FROM SUMMARY) AS sub;