Pregunta de entrevista de ZS Associates

I was asked Multiple SQL question about joins, window functions etc.