TikTok interview question

SQL with a window function