Spotify Interview Question

SQL case, gave some hypothetical scenario, asked to code