排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-03-14 抖音面试真题（1）T+1日留存率  
select a_date login_date, 
 concat(round(count(distinct case when diff="1" then b_date end)/count(distinct usr_id)*100, 2),"%") T1_retention_rate
from (
select 
 distinct a.usr_id, 
 date(a.login_time) as a_date, 
 date(b.login_time) as b_date, 
 datediff(date(b.login_time),date(a.login_time)) as diff
from user_login_log a
left join user_login_log b on a.usr_id = b.usr_id
where datediff(current_date, date(a.login_time)) <= 30
) b
group by a_date
order by a_date
2026-03-14 抖音面试真题（1）T+1日留存率  
select a_date login_date, 
 concat(round(count(distinct case when diff="1" then b_date end)/count(distinct usr_id)*100, 2),"%") T1_retention_rate
from (
select 
 distinct a.usr_id, 
 date(a.login_time) as a_date, 
 b.login_time as b_date, 
 datediff(date(b.login_time),date(a.login_time)) as diff
from user_login_log a
inner join user_login_log b on a.usr_id = b.usr_id
) b
where a_date >= "2024-10-01" and a_date < "2024-11-01"
group by a_date
order by a_date
2026-03-14 一线城市历年平均气温  
SELECT 
YEAR(dt) AS Y,
cast(AVG(CASE WHEN city='beijing' THEN tmp_h END) as decimal(4,2)) AS '北京',
cast(AVG(CASE WHEN city='shanghai' THEN tmp_h END) as decimal(4,2)) AS '上海',
cast(AVG(CASE WHEN city='shenzhen' THEN tmp_h END) as decimal(4,2)) AS '深圳',
cast(AVG(CASE WHEN city='guangzhou' THEN tmp_h END) as decimal(4,2)) AS '广州'
FROM weather_rcd_china
WHERE YEAR(dt) BETWEEN 2011 AND 2022
GROUP BY YEAR(dt)
ORDER BY Y;
2026-03-14 一线城市历年平均气温  
SELECT 
YEAR(dt) AS Y,
ROUND(AVG(CASE WHEN city='beijing' THEN tmp_h END), 2) AS '北京',
ROUND(AVG(CASE WHEN city='shanghai' THEN tmp_h END), 2) AS '上海',
ROUND(AVG(CASE WHEN city='shenzhen' THEN tmp_h END), 2) AS '深圳',
ROUND(AVG(CASE WHEN city='guangzhou' THEN tmp_h END), 2) AS '广州'
FROM weather_rcd_china
WHERE YEAR(dt) BETWEEN 2011 AND 2022
GROUP BY YEAR(dt)
ORDER BY Y;