Three Days in One Read

The session data survived in three daily shards, and QUERY needs to read them as one dataset. Query all tables matching sessions_d* in a single statement, without UNION ALL, and return user_id, platform, minutes, sorted by user_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.

user_id	platform	minutes
101	ios	4
102	android	11
103	web	2

PostgreSQLv16

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid