Pregunta de entrevista de Spotify

Please find 5 ways to refactor this SQL code to reduce technical debt.