|verified| | Tdb V2

SELECT s.temp, w.wind_speed FROM sensor s JOIN weather w ON s.time = w.time WHERE s.device = 'roof'

-- Downsample automatically CREATE CONTINUOUS QUERY auto_downsample ON fleet BEGIN SELECT mean(temp) AS temp_avg, max(temp) AS temp_max INTO fleet.hour.:measurement FROM fleet.raw.:measurement GROUP BY time(1h), * END; tdb v2

The transition to this modernized digital framework has streamlined several critical areas: SELECT s