Soln - Manipulate Date Directly. No need to lead / lag
\nselect round(count(distinct(player_id))/(select count(distinct(player_id)) from Activity),2) fraction\nfrom Activity\nwhere (player_id, event_date) in (select
```\nselect round(count(distinct(player_id))/(select count(distinct(player_id)) from Activity),2) fraction\nfrom Activity\nwhere (player_id, event_date) in (select player_id, DATE_ADD(min(event_date), interval 1 day)\n                                  from Activity\n                                  group by player_id )\n```
[]