30 Days Of LeetCode Database Day 19 - 511. Game Play Analysis I

1Example 1:
2 
3Input: 
4Activity table:
5+-----------+-----------+------------+--------------+
6| player_id | device_id | event_date | games_played |
7+-----------+-----------+------------+--------------+
8| 1         | 2         | 2016-03-01 | 5            |
9| 1         | 2         | 2016-05-02 | 6            |
10| 2         | 3         | 2017-06-25 | 1            |
11| 3         | 1         | 2016-03-02 | 0            |
12| 3         | 4         | 2018-07-03 | 5            |
13+-----------+-----------+------------+--------------+
14Output: 
15+-----------+-------------+
16| player_id | first_login |
17+-----------+-------------+
18| 1         | 2016-03-01  |
19| 2         | 2017-06-25  |
20| 3         | 2016-03-02  |
21+-----------+-------------+

1**SQL**
2 
3SELECT player_id, MIN(event_date) AS 'first_login'
4FROM Activity GROUP BY player_id;