GPT-o3 综合 严格题归零

```sql
WITH daily AS (
    SELECT DISTINCT user_id, login_date
    FROM user_logins
),
numbered AS (
    SELECT
        user_id,
        login_date,
        ROW_NUMBER() OVER (
            PARTITION BY user_id
            ORDER BY login_date
        ) AS rn
    FROM daily
),
streaks AS (
    SELECT
        user_id,
        COUNT(*) AS streak_len
    FROM numbered
    GROUP BY
        user_id,
        login_date - rn * INTERVAL '1 day'
)
SELECT
    user_id,
    MAX(streak_len) AS max_streak
FROM