Most Recent 2020 Login
For each user, find the most recent login that happened in 2020 and return it as last_stamp. Skip users who did not log in during 2020.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| user_id | last_stamp |
|---|---|
| 2 | 2020-01-15T19:49:50.000Z |
| 6 | 2020-06-30T08:06:07.000Z |
| 8 | 2020-12-29T17:46:50.000Z |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid