Detect Consecutive Losing Streaks

Given a table of user betting logs, write a query to identify consecutive losing streaks exceeding a specific threshold for risk assessment.

Assume the threshold is more than 3 consecutive losing bets. A win or a missing result ends the current losing streak.

Output

1. One row per qualifying losing streak, with user_id, streak_start, streak_end, and losing_bets.
2. Include only streaks containing more than 3 losses.
3. Order by user_id, then streak_start, then streak_end.

Output details

• Treat any outcome other than loss, including NULL, as ending the current losing streak.
• Process bets for each user by bet_timestamp ascending, breaking timestamp ties with bet_id ascending.
• Sort user_id, streak_start, and streak_end in ascending order.
• Set streak_start and streak_end to the earliest and latest bet_timestamp values in each streak.