Coding Test

Leetcode - 1890. The Latest Login in 2020

일시불

문제

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.

정답

SELECT user_id, MAX(time_stamp) AS last_stamp
FROM Logins
WHERE time_stamp >= '2020-01-01'  AND time_stamp < '2021-01-01'
GROUP BY user_id