LeetCode-SQL-1097. 游戏玩法分析 V

最新推荐文章于 2022-09-21 13:42:38 发布

什么你竟然不会敲代码

最新推荐文章于 2022-09-21 13:42:38 发布

阅读量305

点赞数

分类专栏：数据库 LeetCode

本文链接：https://blog.csdn.net/m0_37302219/article/details/105068206

版权

LeetCode 同时被 2 个专栏收录

204 篇文章 3 订阅

订阅专栏

数据库

142 篇文章 10 订阅

订阅专栏

SELECT a1.install_dt,COUNT(a1.player_id) AS installs,round(COUNT(a2.player_id)/COUNT(a1.player_id),2) AS Day1_retention
FROM 
(
	SELECT player_id,MIN(event_date) AS install_dt
	FROM Activity
	GROUP BY player_id
) AS a1
left JOIN Activity AS a2
	ON (a2.event_date = DATE_ADD(a1.install_dt,INTERVAL 1 DAY) AND a2.player_id = a1.player_id)
GROUP BY a1.install_dt