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. Your answer must use the same column names as this sample — alias them with AS if needed.

user_id	last_stamp
2	2020-01-16 02:49:50
6	2020-06-30 15:06:07
8	2020-12-30 00:46:50

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid