A new streak starts when a user logs in after missing at least one day. For each distinct (user, date) login, return user_id, login_date and streak_no (1, 2, 3… per user).
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.