Skip to content

Latest commit

 

History

History
12 lines (10 loc) · 374 Bytes

1890. The Latest Login in 2020.md

File metadata and controls

12 lines (10 loc) · 374 Bytes

1890. The Latest Login in 2020

Question Link

Don't Forget to Take the hh:mm:ss into Consideration!

Solution

# Write your MySQL query statement below
select user_id, max(time_stamp) last_stamp from Logins
where time_stamp between '2020-01-01 00:00:00' and '2020-12-31 23:59:59'
group by user_id