ZS Associates interview question

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