力扣---高频SQL题---22---550. 游戏玩法分析 IV

一、题目

二、代码

# Write your MySQL query statement below
-- select co from Activity as table1
-- join
-- (
-- select player_id ,min(event_date ) as min_date ,count(player_id) as co from Activity
-- group by player_id 
-- ) as table2
-- where table1.player_id = table2.player_id
-- and datediff(table1.event_date ,table2.min_date) = 1


select coalesce (