SQL_LeetCode_550_Game Play Analysis IV 풀이 -- ORACLE SELECT ROUND(COUNT(A2.PLAYER_ID) / COUNT(A.PLAYER_ID),2) AS fraction FROM ACTIVITY A LEFT OUTER JOIN ACTIVITY A2 ON A.PLAYER_ID = A2.PLAYER_ID AND A2.EVENT_DATE = A.EVENT_DATE + 1 WHERE (A.PLAYER_ID, A.EVENT_DATE) IN ( SELECT PLAYER_ID, MIN(EVENT_DATE) FROM ACTIVITY GROUP BY PLAYER_ID ) -- MYSQL SELECT ROUND(COUNT(DISTINCT A.PLAYER_ID) / (SELECT COUNT(DISTINCT PLAYER_ID) FROM ACTIVITY),2) AS fraction FROM ACTIVITY A WHERE CONCAT(A.PLAYER_ID, A....
#LeetCode_550_GamePlayAnalysisIV
#SQL
#SQL_GamePlayAnalysisIV
#SQL_LeetCode_550
#SQL_LeetCode_550_GamePlayAnalysisIV
원문링크 : SQL_LeetCode_550_Game Play Analysis IV
네이버 블로그
티스토리
커뮤니티