Leetcode Problem 1097. Game Play Analysis V

1097. Game Play Analysis V

Leetcode Solutions

Create a Common Table Expression (CTE) to identify the first login date for each player.
Use a LEFT JOIN to find players who logged in the day after their first login and create an indicator variable for consecutive logins.
Group the results by the first login date and calculate the number of installs and the sum of the indicator variable.
Calculate the day one retention rate by dividing the sum of the indicator variable by the number of installs and rounding to two decimal places.
Select the required columns for the final output.


erDiagram
    Activity {
        int player_id
        int device_id
        date event_date
        int games_played
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen