Gaming Analytics 2: Device Choice

For each player find the device they used on their very first login. Return player_id and device_id.

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	device_id
1	2
2	3
3	1

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid