Aggregate: AVG

.mode batch
.import --csv examples/iris.csv iris


SELECT AVG(SepalLengthCm) FROM iris;
SELECT AVG(PetalLengthCm) FROM iris;
SELECT AVG(PetalLengthCm), Species FROM iris GROUP BY Species;

$ sqlite3 < examples/averages-iris.sql

5.8433333333333337
3.7586666666666662
1.464|Iris-setosa
4.26|Iris-versicolor
5.5520000000000005|Iris-virginica