Freaks City

To determine the fraction of players who log in on the day immediately following their first login, we analyze the Activity table, which records player events with timestamps. First, identify each player’s earliest login date and compute the expected return date — that is, the day after their first activity: SELECT player_id, DATE_ADD(MIN(event ...