Coding Test

문제 Loading...Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.LeetCode 정답…

문제 https://leetcode.com/problems/game-play-analysis-i/ 정답 SELECT player_id, MIN(event_date) as first_login FROM Activity GROUP BY player_id…

문제 https://leetcode.com/problems/user-activity-for-the-past-30-days-i/ 정답 SELECT activity_date as day, COUNT(DISTINCT user_id) as active_users FROM Activity # BETWEEN is inclusive so subtract 29 days WHERE activity_…

문제 https://leetcode.com/problems/article-views-i/submissions/ 정답 SELECT author_id as 'id' FROM Views WHERE author_id = viewer_id GROUP BY author_id ORDER BY author_id…

문제 https://leetcode.com/problems/market-analysis-i/ 정답 SELECT user_id AS buyer_id, join_date, IFNULL(COUNT(order_date), 0) AS orders_in_2019 FROM Users LEFT JOIN Orders ON…

문제 Loading...Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.LeetCode 정답…

문제 Loading...Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.LeetCode 정답…

문제 Loading...Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.LeetCode 정답…

문제 Loading...Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.LeetCode 정답…

문제 Loading...Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.LeetCode 정답…