if i use command
SELECT * FROM "°C"
i get
1642433272850788096 temperature 1283010952991 /sys/bus/w1/devices/28-3c01f095c299/w1_slave sensor room2_temperature Pokój 2 20.75 measurement 20.8
1642433272930414848 temperature 1283010951911 /sys/bus/w1/devices/28-3c01f09519d1/w1_slave sensor room1_temperature Pokój 1 20.812 measurement 20.8
164243330292988620
and if i create this
CREATE CONTINUOUS QUERY "cq_basic" ON "home_assistant" BEGIN SELECT mean(*) INTO "average_measuments" FROM "°C" GROUP BY time(5m) END
and do this
SELECT * FROM "average_measuments"
then nothing happend.
What i do wrong ?