Leetcode 550. Game Play Analysis IV

weixin_49156016

已于 2022-11-09 04:58:56 修改

阅读量83

点赞数

于 2022-11-09 04:57:42 首次发布

本文链接：https://blog.csdn.net/weixin_49156016/article/details/127762198

版权

SQL 窗口函数数据分析游戏分析连续登录

关键词由CSDN通过智能技术生成

with tmp as (select  distinct player_id , event_date, games_played,
lag(event_date,1) over (partition by player_id order by event_date) as lag2,
             rank()over(partition by player_id order by event_date) as login_times
from activity) 


 


select round(count(distinct player_id) / (select count(distinct player_id) from activity),2) as fraction from tmp
 where timestampdiff(day,lag2,event_date) =1 and login_times=2

尝试使用窗口函数来解。

其他简单方式可参照：https://pallavismile9.medium.com/sql-leetcode-550-game-play-analysis-iv-a3920e2a521f