Easiest Solution
Intution\nDATE_ADD function will help to tackle the leap year problem. Don\'t use event_date + 1 or something.\nHappy learning!\nThanks\n\n# Code\n\n# Write you
# Intution\nDATE_ADD function will help to tackle the leap year problem. Don\'t use event_date + 1 or something.\nHappy learning!\nThanks\n\n# Code\n```\n# Write your MySQL query statement below\nSELECT ROUND(COUNT(DISTINCT a2.player_id)/COUNT(DISTINCT a1.player_id), 2) fraction FROM (SELECT player_id, MIN(event_date) event_date FROM Activity\nGROUP BY player_id) a1 LEFT JOIN Activity a2 ON (a1.player_id=a2.player_id) and (DATE_ADD(a1.event_date, INTERVAL 1 DAY) = a2.event_date)\n\n```
['MySQL']