# Pastebin qRAzNtzl Red-Driver-DuckDB on  main [?] via 🦋 v6.d-moar ✦ λ raku -I. -e ' my $*RED-DEBUG = True; use Red; red-defaults "DuckDB"; red-do { my \T = .read-csv: "iot-sensor-100.csv", :name; say T.^all .classify(*.device) .map(-> (:key($device), :value($rows)) { my $count = $rows.elems; my $values = $rows.map(*.value); [$device, $count, $values.sum / $count, $values.min, $values.max] }) .sort(*[0]) .Array } ' SQL : DESCRIBE SELECT * FROM read_csv('iot-sensor-100.csv') BIND: [] SQL : CREATE TEMP VIEW "iot" AS SELECT "id" AS "id", "device" AS "device", "value" AS "value" FROM read_csv('iot-sensor-100.csv') BIND: [] SQL : SELECT DISTINCT("iot".device) as "data_1" FROM "iot" BIND: [] SQL : SELECT count('*') as "data_1" FROM "iot" WHERE "iot".device = ? LIMIT 1 BIND: [2] SQL : SELECT SUM("red_projection_0"."data_1") as "data_1", COUNT('*') as "data_2", COUNT("red_projection_0"."data_1") as "data_3" FROM ( SELECT "iot".value as "data_1" FROM "iot" WHERE "iot".device = ? ) AS "red_projection_0" LIMIT 1 BIND: [2] SQL : SELECT MIN("red_projection_1"."data_1") as "data_1", COUNT('*') as "data_2", COUNT("red_projection_1"."data_1") as "data_3" FROM ( SELECT "iot".value as "data_1" FROM "iot" WHERE "iot".device = ? ) AS "red_projection_1" LIMIT 1 BIND: [2] SQL : SELECT MAX("red_projection_2"."data_1") as "data_1", COUNT('*') as "data_2", COUNT("red_projection_2"."data_1") as "data_3" FROM ( SELECT "iot".value as "data_1" FROM "iot" WHERE "iot".device = ? ) AS "red_projection_2" LIMIT 1 BIND: [2] SQL : SELECT count('*') as "data_1" FROM "iot" WHERE "iot".device = ? LIMIT 1 BIND: [1] SQL : SELECT SUM("red_projection_3"."data_1") as "data_1", COUNT('*') as "data_2", COUNT("red_projection_3"."data_1") as "data_3" FROM ( SELECT "iot".value as "data_1" FROM "iot" WHERE "iot".device = ? ) AS "red_projection_3" LIMIT 1 BIND: [1] SQL : SELECT MIN("red_projection_4"."data_1") as "data_1", COUNT('*') as "data_2", COUNT("red_projection_4"."data_1") as "data_3" FROM ( SELECT "iot".value as "data_1" FROM "iot" WHERE "iot".device = ? ) AS "red_projection_4" LIMIT 1 BIND: [1] SQL : SELECT MAX("red_projection_5"."data_1") as "data_1", COUNT('*') as "data_2", COUNT("red_projection_5"."data_1") as "data_3" FROM ( SELECT "iot".value as "data_1" FROM "iot" WHERE "iot".device = ? ) AS "red_projection_5" LIMIT 1 BIND: [1] [[1 1 1 1 1] [2 1 2 2 2]]