SELECT
ROUND(COUNT(DISTINCT b.player_id)/COUNT(DISTINCT a.player_id),2) AS "fraction"
FROM(
SELECT
player_id,
min(event_date) AS first_date
FROM Activity
GROUP BY player_id) a
LEFT JOIN Activity b
ON a.player_id=b.player_id
AND datediff(b.event_date,a.first_date)=1
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交