Skip to main content

511. Game Play Analysis I

Giới thiệu bài toán​

Chi tiết: https://leetcode.com/problems/game-play-analysis-i/

Table: Activity

Column NameType
player_idint
device_idint
event_datedate
games_playedint
  • (player_id, event_date) is the primary key (combination of columns with unique values) of this table.
  • This table shows the activity of players of some games.
  • Each row is a record of a player who logged in and played a number of games (possibly 0) before logging out on someday using some device.
Yêu cầu

Write a solution to find the first login date for each player.

Return the result table in any order. The result format is in the following example.

Giải quyết bài toán​

SELECT 
    player_id, 
    MIN(event_date) AS first_login
FROM Activity
GROUP BY player_id;

Tham khảo: https://leetcode.com/submissions/detail/1039350725/