31/10/2022
List the names who have won consecutively at least 3 times within a span of 180 days.
Span of 180 days is last win date - first win date in a consecutive streak of wins.
2022-01-15 Y
2022-01-28 N
2022-02-12 Y
2022-03-18 Y
2022-05-12 Y
Here all 3 consecutive wins are within 180 days
2022-05-12 - 2022-02-12 : 89 days (The winning streak of at least 3 consecutive wins start on 2022-02-12 not on 2022-01-15)
2022-01-15 Y
2022-01-28 Y
2022-02-12 N
2022-03-18 Y
2022-05-12 Y
Here, 2022-02-12 N - Breaks at least 3 consecutive criterion
If you may have more than one consecutive streaks of at least 3 consecutive wins, in this case, list any one of them.
2022-01-15 Y
2022-01-28 Y
2022-01-31 Y
2022-02-12 N
2022-03-18 Y
2022-05-12 Y
2022-06-08 Y
2022-06-28 Y
Here, there are 2 streaks of consecutive wins
Streak 1
2022-01-15 Y
2022-01-28 Y
2022-01-31 Y
Streak 2
2022-03-18 Y
2022-05-12 Y
2022-06-08 Y
2022-06-28 Y
List either of them. My preference would be Streak 1.
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
