image_2022-04-12_23-43-07.png
21.4 KB
#N1890. The Latest Login in 2020
problem link
#solution
problem link
#solution
select user_id,
max(time_stamp) as last_stamp
from logins
where year(time_stamp)=2020
group by user_id