Gaming Analytics 1: Initial Login

For each player find the date of their first login. Return player_id and first_login.

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.

player_id	first_login
3	2024-01-02
4	2024-01-07
2	2024-01-03

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid