Single-query rolling median and range-bounded COUNT(DISTINCT) after filtering nested intervals in SQLite
Language: SQL · Versions: SQLite 3.53.0 (also reproducible in PostgreSQL 17) The problem I'm computing a 7-day rolling median and a 7-day rolling distinct-user count over sparse…
4 posts ·