Three Days Running
logins has a row for every login: day is a day number (day 1, day 2, and so on), and a user may log in several times on one day. Return each user_id that logged in on at least three days in a row, once. Rows may come in any order.
Example 1
logins
| user_id | day |
|---|---|
| 1 | 4 |
| 1 | 5 |
| 1 | 5 |
| 1 | 6 |
| 2 | 1 |
| 2 | 2 |
| 2 | 4 |
| 2 | 5 |
returns
| user_id |
|---|
| 1 |
Constraints
- Up to 42 logins
Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.
More SQL problems
- Top Two Salaries per DepartmentHard
- Worst DrawdownHard
- Between Two PricesBeginner
- Both ConditionsBeginner
- Cheapest FirstBeginner
- Each Symbol OnceBeginner
- How Many SellsBeginner
- No ManagerBeginner