SELECT StationID, AVG(Temperature) OVER (PARTITION BY StationID, window(ReadingTimestamp, โ1 hourโ, โ30 minutesโ)) FROM WeatherReadings;
SELECT StationID, window(ReadingTimestamp, โ1 hourโ), AVG(Temperature) FROM WeatherReadings GROUP BY StationID, window(ReadingTimestamp, โ1 hourโ);
SELECT StationID, AVG(Temperature) OVER (PARTITION BY StationID ORDER BY ReadingTimestamp ROWS BETWEEN INTERVAL โ30 minutesโ PRECEDING AND INTERVAL โ30 minutesโ FOLLOWING) FROM WeatherReadings;
SELECT StationID, AVG(Temperature) OVER (PARTITION BY StationID ORDER BY ReadingTimestamp RANGE BETWEEN INTERVAL 1 HOUR PRECEDING AND CURRENT ROW) FROM WeatherReadings;
SELECT StationID, window(ReadingTimestamp, โ1 hourโ, โ30 minutesโ), AVG(Temperature) FROM WeatherReadings GROUP BY StationID, window(ReadingTimestamp, โ1 hourโ, โ30 minutesโ);
None