Flipkart interview question

joins, window functions, guess estimates