Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
with source as
(
select * from ecds_db.playground.time11M
),
timeline as
(
select start_at as moment
from source
union
select end_at as moment
from source
),
concurrency as
(
select t.moment, count(s.id) as count
from timeline t
join source s on t.moment between s.start_at and s.end_at
group by t.moment
)
select max(count)
from concurrency
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment