The query below returns the output shown in the following table.
SELECT * FROM nb_iris_model ORDER BY 1;
class | variable | type | category | cnt | sum | sumSq | totalcnt |
---|---|---|---|---|---|---|---|
setosa | sepal_width | NUMERIC | 40 | 136.700000524521 | 473.290003499985 | 40 | |
setosa | petal_width | NUMERIC | 40 | 10.1000002026558 | 3.03000012755394 | 40 | |
setosa | sepal_length | NUMERIC | 40 | 199.900000095367 | 1004.27000005722 | 40 | |
setosa | petal_length | NUMERIC | 40 | 57.6999998092651 | 84.2099996709824 | 40 | |
versicolor | sepal_width | NUMERIC | 40 | 111.10000038147 | 313.130002088547 | 40 | |
versicolor | petal_width | NUMERIC | 40 | 53.299999833107 | 72.7099995040894 | 40 | |
versicolor | sepal_length | NUMERIC | 40 | 239.599999427795 | 1446.13999296188 | 40 | |
versicolor | petal_length | NUMERIC | 40 | 172.399999141693 | 752.219992570878 | 40 | |
virginica | sepal_width | NUMERIC | 40 | 118.799999952316 | 356.539999780655 | 40 | |
virginica | petal_width | NUMERIC | 40 | 81.1999989748001 | 166.999995970726 | 40 | |
virginica | sepal_length | NUMERIC | 40 | 264.400000572205 | 1764.92000530243 | 40 | |
virginica | petal_length | NUMERIC | 40 | 222.299999713898 | 1249.1499958992 | 40 |