sql22（Leetcode550游戏玩法分析4）

最新推荐文章于 2024-09-30 14:51:11 发布

从月亮走向月亮7

最新推荐文章于 2024-09-30 14:51:11 发布

阅读量371

点赞数 7

文章标签： leetcode

本文链接：https://blog.csdn.net/stacey777/article/details/134665130

版权

代码：

😵‍💫

# Write your MySQL query statement below
select ifnull(round(count(distinct(Result.player_id))/count(distinct(Activity.player_id)),2),0) as fraction
from(
    select Activity.player_id as player_id
    from(
        select player_id,date_add(min(event_date),interval 1 day) as second_date
        from Activity
        group by player_id
    ) as Excepted,Activity
    where Activity.event_date = Excepted.second_date and Activity.player_id=Excepted.player_id) as Result,Activity