# Pastebin tGfP7d72 Red-Driver-DuckDB on  main [?] via 🦋 v6.d-moar took 6s ✦ λ raku -I. -I../Red -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 "red_projection_0"."data_1" as "data_1", "red_projection_0"."data_2" as "data_2", "red_projection_0"."data_3" as "data_3", "red_projection_0"."data_4" as "data_4", "red_projection_0"."data_5" as "data_5" FROM ( SELECT '' || "iot".device as "data_1", COUNT('*') as "data_2", (1.0 * SUM("iot".value)) / COUNT('*') as "data_3", MIN("iot".value) as "data_4", MAX("iot".value) as "data_5" FROM "iot" WHERE "iot".device IS NOT NULL GROUP BY "iot".device ) AS "red_projection_0" ORDER BY "red_projection_0"."data_1" BIND: [] [[1 1 1 1 1] [2 1 2 2 2]]