Skip to content

1890. The Latest Login in 2020 👍

1
2
3
4
5
6
SELECT
  user_id,
  MAX(time_stamp) AS last_stamp
FROM Logins
WHERE YEAR(time_stamp) = 2020
GROUP BY 1;