Game Play Analysis IV SQL MySQL leetcode solution

Опубликовано: 15 Май 2024
на канале: CodeWis Technologies by Nuhman Paramban

Challenge: Returning Players Analysis

Difficulty: Medium

Data:

A table named Activity stores information about player activity in a game:

player_id (int): Unique identifier for a player.
device_id (int): Identifier for the device used by the player (may not be unique).
event_date (date): Date the player logged in and played games.
games_played (int): Number of games played during the login session (may be 0).
Objective:

Calculate the percentage (rounded to 2 decimal places) of players who logged in on consecutive days, starting from their first login date. In other words, find the proportion of players with activity records for two consecutive dates.

Output:

A table with a single column:

fraction (float): Percentage of players with consecutive login days, rounded to 2 decimal places.
Explanation:

We need to identify players who have entries in the Activity table for both their first login date and the day after their first login date.

Leetcode SQL MySQL challenges
problem solutions

На этой странице сайта вы можете посмотреть видео онлайн Game Play Analysis IV SQL MySQL leetcode solution длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь CodeWis Technologies by Nuhman Paramban 15 Май 2024, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 15 раз и оно понравилось 0 зрителям. Приятного просмотра!

742