hard20 pts · first answer countswindow-functionssqlgaps-and-islands

Streaks broken by repeat logins

A login streak query uses login_date - ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY login_date). Users who log in twice on some days get wrong streaks. What fixes it?

A.Reduce to one row per user per date before numberingB.Use RANK instead of ROW_NUMBER for the numberingC.Order by the login timestamp instead of the dateD.Add login_date to the PARTITION BY of the window

Discussion 0

Join free to post in the discussion.

Streaks broken by repeat logins

Discussion 0

Related questions