SQL 求每位玩家最早登录的时间

标签：event 03 每位 玩家 player +-----------+-----------+------------+--------------+ SQL 

https://leetcode.cn/problems/game-play-analysis-i/submissions/

 

Activity 表：
+-----------+-----------+------------+--------------+
| player_id | device_id | event_date | games_played |
+-----------+-----------+------------+--------------+
| 1 | 2 | 2016-03-01 | 5 |
| 1 | 2 | 2016-05-02 | 6 |
| 2 | 3 | 2017-06-25 | 1 |
| 3 | 1 | 2016-03-02 | 0 |
| 3 | 4 | 2018-07-03 | 5 |
+-----------+-----------+------------+--------------+

 

select player_id,   min(event_date) first_login from activity group by player_id

标签：event,03,每位,玩家,player,+-----------+-----------+------------+--------------+,SQL,
From： https://www.cnblogs.com/Dongmy/p/16950880.html