ORACLE CTE MIN() OVER()
with cte as ( select player_id, event_date, min(event_date) over (partition by player_id) min_date\n              FROM Activity)\n              \nSELECT round(c
with cte as ( select player_id, event_date, min(event_date) over (partition by player_id) min_date\n              FROM Activity)\n              \nSELECT round(count(case when event_date = min_date + 1 then 1 else null end) / count(distinct player_id),2) fraction\n\nFROM cte
['Oracle']