A social media platform tracks user logins and wants to analyze user engagement. Write a SQL query to find the longest consecutive streak of login days for each user.
user_logins (user_id, login_date)
| user_id | login_date |
|---|---|
| 1 | 2024-01-01 |
| 1 | 2024-01-02 |
| 1 | 2024-01-04 |
| 2 | 2024-01-01 |
| 2 | 2024-01-02 |
| 2 | 2024-01-03 |
| 2 | 2024-01-05 |
| 3 | 2024-01-03 |
| 3 | 2024-01-05 |
| 3 | 2024-01-06 |
| 3 | 2024-01-07 |
| user_id | longest_streak |
|---|---|
| 1 | 2 |
| 2 | 4 |
| 3 | 4 |