SELECT ROUND(COUNT(DISTINCT t1.player_id) / (SELECT COUNT(DISTINCT player_id) FROM Activity),2) AS fraction FROM Activity t1 JOIN Activity t2 ON DATEDIFF(t2.event_date, t1.event_date) = 1 AND t2.player_id = t1.player_id Can anyone tell why this solution is considered wrong?
What did you think of this question!? 😃
SELECT ROUND(COUNT(DISTINCT t1.player_id) / (SELECT COUNT(DISTINCT player_id) FROM Activity),2) AS fraction
FROM Activity t1
JOIN Activity t2 ON DATEDIFF(t2.event_date, t1.event_date) = 1 AND t2.player_id = t1.player_id
Can anyone tell why this solution is considered wrong?