Domanda di colloquio di ZS Associates

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