Comments 2 条评论

• 

  博主 jm

  登录以回复

  发布于 2024-03-26 15:32  (  Chrome 107   macOS Catalina or Higher 10.15.7 )(    ) 来自: 中国 上海 上海

  看看金科网站

  ---

• 

  博主 蹲在墙角哭

  登录以回复

  发布于 2024-03-26 16:50  (  Chrome 122   Windows 10/11 )(    ) 来自: 中国 北京市 北京

  [code]
  — 第一题 最大连续活跃天数
  select
  user_id,
  max(act_day) max_act_day
  from
  (
  select
  user_id,
  gp,
  count(*) act_day
  from
  (
  select
  user_id,
  date_sub(
  login_date,
  row_number() over(
  partition by
  user_id
  order by
  login_date
  )
  ) gp
  from
  (
  select
  user_id,
  date_format(online_time, ‘yyyy-MM-dd’) login_date
  from
  (
  select
  1 user_id,
  ‘2024-01-01 01:01:01’ online_time
  union all
  select
  1 user_id,
  ‘2024-01-02 01:01:01’ online_time
  union all
  select
  1 user_id,
  ‘2024-01-03 01:01:01’ online_time
  union all
  select
  1 user_id,
  ‘2024-01-05 01:01:01’ online_time
  union all
  select
  2 user_id,
  ‘2024-01-02 01:01:01’ online_time
  union all
  select
  2 user_id,
  ‘2024-01-05 01:01:01’ online_time
  union all
  select
  2 user_id,
  ‘2024-01-06 01:01:01’ online_time
  union all
  select
  2 user_id,
  ‘2024-01-07 01:01:01’ online_time
  union all
  select
  3 user_id,
  ‘2024-01-01 01:01:01’ online_time
  union all
  select
  3 user_id,
  ‘2024-01-02 01:01:01’ online_time
  union all
  select
  3 user_id,
  ‘2024-01-03 01:01:01’ online_time
  ) tmp
  group by
  user_id,
  login_date
  )
  )
  group by
  user_id,
  gp
  ) group by user_id;
  [/code]

  ---