题解 | 最长连续登录天数

SELECT
  user_id,
  MAX(consec_days) max_consec_days
FROM
  (
  SELECT
    user_id,
    count( dates ) consec_days 
  FROM
    (
    SELECT
      user_id,
      DATE_ADD( fdate, INTERVAL - ROW_NUMBER() over ( PARTITION BY user_id ) DAY ) dates 
    FROM
      tb_dau 
    GROUP BY
      user_id,
      fdate 
    ) t 
  GROUP BY
    user_id,
  dates 
  ) continue_userlog
  GROUP BY user_id