[문제]
[MySQL]
SELECT user_id
, MAX(time_stamp) AS last_stamp
FROM Logins
WHERE YEAR(time_stamp) = 2020
GROUP BY user_id
'SQL > LeetCode' 카테고리의 다른 글
| [LeetCode] 1934. Confirmation Rate (0) | 2025.02.21 |
|---|---|
| [LeetCode] 1907. Count Salary Categories (0) | 2025.02.21 |
| [LeetCode] 1873. Calculate Special Bonus (0) | 2025.02.21 |
| [LeetCode] 1795. Rearrange Products Table (0) | 2025.02.21 |
| [LeetCode] 1789. Primary Department for Each Employee (0) | 2025.02.21 |