Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
with source as
select * from ecds_db.playground.time11M
timeline as
select id, start_at as happened_at, 1 as balance
from source
union all
select id, end_at as happened_at, -1 as balance
from source
concurrency as
select id, happened_at, balance, sum(balance) over (partition by 1 order by happened_at, id, balance desc rows between unbounded preceding and current row) as count
from timeline
select max(count)
from concurrency
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment