Domanda di colloquio di LatentView Analytics

A difficult level SQL question on multiple joins and window functions within a single query