Door Activity

Custom SQL query returning 1 row (hide)

WITH changes AS (
  SELECT
    recorded_at,
    door_status,
    LAG(door_status) OVER (ORDER BY recorded_at) AS previous_status
  FROM sensor_log
)
SELECT recorded_at, door_status
FROM changes
WHERE previous_status IS NULL OR door_status <> previous_status
ORDER BY recorded_at;

Edit SQL