Sessions Without Purchase Counts
Sessions Without Purchase Counts
To review activity on March 15, QUERY needs a lean session export without purchase counts. From sessions_d20260315, return every column except purchases; exclude that field from * instead of listing the remaining columns manually. Sort 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 |
|---|---|---|
| 103 | web | 2 |
| 104 | ios | 7 |
| 108 | android | 9 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid