排名

用户解题统计

过去一年提交了

勋章 ①金银铜：在竞赛中获得第一二三名；②好习惯：自然月10天提交；③里程碑：解决1/2/5/10/20/50/100/200题；④每周打卡挑战：完成每周5题，每年1月1日清零。

收藏

收藏日期 题目名称 解决状态
没有收藏的题目。

评论笔记

评论日期 题目名称 评论内容 站长评论
没有评论过的题目。

提交记录

提交日期 题目名称 提交代码
2025-04-16 天王天后的发烧友  
SELECT 
user_id,
MAX(consecutive_days) AS max_consecutive_days
FROM (
SELECT 
user_id,
COUNT(*) AS consecutive_days
FROM (
SELECT 
user_id,
DATE_SUB(date_day, INTERVAL rank_day DAY) AS base_date
FROM (
SELECT 
user_id,
DATE(start_time) AS date_day,
ROW_NUMBER() OVER (
PARTITION BY user_id 
ORDER BY DATE(start_time)
) AS rank_day
FROM listen_rcd
GROUP BY user_id, DATE(start_time)
) t1
) t2
GROUP BY user_id, base_date
) t3
GROUP BY user_id;
2025-04-16 天王天后的发烧友  
select user_id,max(datecounts) max_consecutive_days
from
(select
user_id,count(new_date) datecounts
from
(select user_id,DATE_SUB(date_day, INTERVAL rank_day DAY) AS new_date
from
(select user_id,
date_day,
row_number()over(partition by user_id order by date_day) rank_day
from
(SELECT DISTINCT
user_id,
DATE(start_time) AS date_day
FROM listen_rcd
order by user_id,date_day) t) t) t
group by user_id,new_date) t
group by user_id