[SQL]game-play-analysis-iv

https://leetcode.com/problems/game-play-analysis-iv

Game Play Analysis IV - LeetCode

with cond as (
    select
        distinct player_id
        , datediff(lead(event_date, 1) over (partition by player_id order by event_date), min(event_date) over (partition by player_id)) cond
    from Activity
    order by player_id, event_date
)
select
    round(count(distinct c.player_id)/count(distinct a.player_id), 2) as fraction
from Activity a
left join cond c on a.player_id = c.player_id
    and c.cond = 1