Spotify Interview Question

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