ZS Associates Interview Question

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