sliding-windows-label-by-hour.sql

SELECT
    tm AS transaction_timestamp,    
    -- Calculate the window label
    DATE_FORMAT(
        DATE_ADD(tm, INTERVAL ((60 - MINUTE(NOW()))*60)-1 SECOND),
        CONCAT('%Y-%m-%d %H:', MINUTE(NOW()))
    ) AS window_label
FROM
    subscriber_history_tracking
WHERE
    result = 1
    AND tm >= "2024-03-04 00:24:00"
LIMIT 100;