Spotify interview question

SQL case, gave some hypothetical scenario, asked to code