kgorman · October 25, 2019 14:52
diff --git a/sample.sql b/sample.sql
 -- new to my airspace
 SELECT icao, pings FROM (
    SELECT icao, speed,
    COUNT(*) OVER (PARTITION BY icao ORDER BY eventTimestamp RANGE BETWEEN INTERVAL '60' SECOND PRECEDING AND CURRENT ROW) AS pings
    FROM airplanes
 ) WHERE pings < 5
 AND icao like 'A%'
	-- new to my airspace
	SELECT icao, pings FROM (
	SELECT icao, speed,
	COUNT(*) OVER (PARTITION BY icao ORDER BY eventTimestamp RANGE BETWEEN INTERVAL '60' SECOND PRECEDING AND CURRENT ROW) AS pings
	FROM airplanes
	) WHERE pings < 5
	AND icao like 'A%'