Tiger Analytics interview question

Real-time problem statement and my approach on it