题目 : https://leetcode.cn/problems/game-play-analysis-i/
数据
Create table If Not Exists Activity (
player_id int,
device_id int,
event_date date,
games_played int
);
insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-03-01', '5')
insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-05-02', '6')
insert into Activity (player_id, device_id, event_date, games_played) values ('2', '3', '2017-06-25', '1')
insert into Activity (player_id, device_id, event_date, games_played) values ('3', '1', '2016-03-02', '0')
insert into Activity (player_id, device_id, event_date, games_played) values ('3', '4', '2018-07-03', '5')
需求
查询每位玩家 第一次登陆平台的日期
查询结果 :
| player_id | first_login |
| 1 | 2016-03-01 |
| 2 | 2017-06-25 |
| 3 | 2016-03-02 |
解决
select player_id,
min(event_date) as first_login
from Activity
group by player_id;