Sporty Group interview question

Improve a SQL query after discovering that it's slow