[SQL]human-traffic-of-stadium

https://leetcode.com/problems/human-traffic-of-stadium

LeetCode - The World's Leading Online Programming Learning Platform

with base as (
    select
        distinct id, visit_date, people
        , id - row_number() over (order by id) as rn
    from Stadium
    where people >= 100
)
, base2 as (
    select
        rn, count(distinct id) cnt
    from base
    group by 1
)
select
    distinct id, visit_date, people
from base
where rn in (select distinct rn from base2 where cnt >= 3)
order by 2