SQL 문제 26 - Game Play Analysis I LeetCode 511 Game Play Analysis I 풀이 -- ORACLE SELECT PLAYER_ID , TO_CHAR(MIN(EVENT_DATE),'YYYY-MM-DD') AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID; -- MYSQL SELECT PLAYER_ID , MIN(EVENT_DATE) AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID; -- MSSQL SELECT PLAYER_ID , CONVERT(CHAR(10),MIN(EVENT_DATE),120) AS FIRST_LOGIN FROM ACTIVITY GROUP BY PLAYER_ID; * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge a...
#
GamePlayAnalysisI_LeetCode511
#
SQL
#
SQL_GamePlayAnalysisI
#
SQL_GamePlayAnalysisI_LeetCode511
#
SQL_LeetCode511
