目录

力扣550. 游戏玩法分析 IV

力扣550. Game Play Analysis IV(游戏玩法分析 IV)

SQL:首次登录后第二天登录的玩家比例。

示例 1:

../posts/01_学习/87_LeetCode/0550_游戏玩法分析IV/img/550-1-description.png

输入:Activity table:
+---------+---------+------------+-----------+----------+
| player_id | device_id | event_date | games_played |
+---------+---------+------------+-----------+----------+
| 1 | 2 | 2016-03-01 | 5 |
| 1 | 2 | 2016-03-02 | 6 |
| 2 | 3 | 2017-06-25 | 1 |
| 3 | 1 | 2016-03-02 | 0 |
| 3 | 4 | 2018-07-03 | 5 |
+---------+---------+------------+-----------+----------+
输出:
+------+
| fraction |
+------+
| 0.33 |
+------+

提示:

  • 详见原题。