Repeated Log Value Streaks

You are analyzing an event stream stored in a table named Logs with the schema:

• id: unique event identifier
• num: observed categorical value for that event

Your task is to find every value that appears in a streak of at least 3 consecutive log entries.

Important definition for this problem:

• First sort rows by id in ascending order.
• A streak is evaluated on adjacent rows in that sorted order.
• If a value has one or more streaks of length >= 3, it should appear exactly once in the result.

Return a single-column result named:

• ConsecutiveNums

Result row order is not important.

This problem must be solved for both:

• SQL (SQLite 3.27.2)
• Pandas

Logs:
| id | num |
|----|-----|
| 1  | 1   |
| 2  | 1   |
| 3  | 1   |
| 4  | 2   |
| 5  | 1   |
| 6  | 2   |
| 7  | 2   |

[
  {"ConsecutiveNums":"1"}
]

Logs:
| id | num |
|----|-----|
| 10 | A   |
| 20 | A   |
| 30 | A   |
| 40 | B   |
| 50 | B   |
| 60 | B   |
| 70 | C   |

[
  {"ConsecutiveNums":"A"},
  {"ConsecutiveNums":"B"}
]

Logs:
| id | num |
|----|-----|
| 1  | x   |
| 2  | y   |
| 3  | x   |
| 4  | y   |
| 5  | z   |

[]