Your Dashboard
Interview Coaching
Learn
System Design
ML System Design
Code
Behavioral
Salary Negotiation
Interview Guides
Search
⌘K
Get Premium
Leetcode 1097. Game Play Analysis V
Given a table of game-play events (user_id, event_date), identify users who match a specified complex temporal play pattern (e.g., consecutive-day streaks or retention criteria) by computing and comparing per-user date sequences. The challenge focuses on date arithmetic, grouping/partitioning and window functions to derive streaks, counts and retention efficiently in SQL.
Question Timeline
See when this question was last asked and where, including any notes left by other candidates.
All Regions
Comments
Hello Interview Premium
Your account is free and you can post anonymously if you choose.