排名

用户解题统计

过去一年提交了

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

错题集 数据思维刷题中答错的题目

模块 知识点 题目 你的答案 正确答案 操作
暂无错题，继续保持！

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-09-27 必过(0, 1)的一元一次函数  
select distinct * from numbers_for_fun where c=1 and a=0 and b<>0order by id
2026-09-27 必过(0, 1)的一元一次函数  
select * from numbers_for_fun where c=1 and a=0 order by id
2026-09-27 必过(0, 1)的一元一次函数  
select * from numbers_for_fun where c=1 and a=0
2026-09-27 必过(0, 1)的一元一次函数  
select * from numbers_for_fun where c=1
2026-09-27 人数最多的学生姓氏  
with data1 as(
select left(name,1) surname from students 
)
select surname,count(*)cnt from data1 group by surname order by cnt desc limit 5
2026-09-27 国庆假期后第一天涨幅高于1%的股票  
select ts_code, open_price,close_price from daily_stock_prices 
where
trade_date ='2023-10-09' 
and pct_change>=1
2026-09-27 国庆假期后第一天涨幅高于1%的股票  
select * from daily_stock_prices 
where
trade_date ='2023-10-09' 
and pct_change>=1
2026-09-27 不分类别的最火直播间  
with data1 as(
select
*
from
ks_live_t1 t1
where
    DATE_FORMAT(t1.enter_time, '%Y-%m-%d %H') = '2021-09-12 23'
)
select 
a.live_id,
b.live_nm,
count(a.usr_id) enter_cnt
from
data1 a left join ks_live_t2 b
on a.live_id=b.live_id
group bya.live_id,b.live_nm
order by enter_cnt desc limit 5
2026-09-27 抖音面试真题（1）T+1日留存率  
with data1 as (
    select distinct 
        usr_id,
        date(login_time) as login_date 
    from 
        user_login_log 
    where 
        datediff(current_date, date(login_time)) <= 30
),
data2 as(
select
a.usr_id,a.login_date,b.login_date login_date_1
 from
data1 a left join data1 b
on
a.usr_id=b.usr_id
where
datediff(a.login_date, b.login_date) = -1
)
select t1.login_date, IFNULL(concat(round(b/a*100,2),'%'),'0.00%')as T1_retention_rate from 
(select login_date ,count(*) a from data1 group by login_date) t1
left join
(select login_date ,count(*) b from data2 group by login_date) t2 on t1.login_date=t2.login_date
order by t1.login_date
2026-09-27 抖音面试真题（1）T+1日留存率  
with data1 as (
    select distinct 
        usr_id,
        date(login_time) as login_date 
    from 
        user_login_log 
    where 
        datediff(current_date, date(login_time)) <= 30
),
data2 as(
select
a.usr_id,a.login_date,b.login_date login_date_1
 from
data1 a left join data1 b
on
a.usr_id=b.usr_id
where
datediff(a.login_date, b.login_date) = -1
)
select t1.login_date, concat(round(b/a*100,2),'%') as T1_retention_rate from 
(select login_date ,count(*) a from data1 group by login_date) t1
left join
(select login_date ,count(*) b from data2 group by login_date) t2 on t1.login_date=t2.login_date
order by t1.login_date
2026-09-27 抖音面试真题（1）T+1日留存率  
with data1 as(
select distinct usr_id, date(login_time) as login_time from user_login_log wheredate(login_time)<=current_dateand date(login_time)>current_date-30 order by usr_id,login_time desc
),
data2as(
select 
t1. usr_id,
t1.login_time login_time1,
t2.login_time login_time2
from data1 t1
left join data1 t2 
on 
t1.usr_id = t2.usr_id
)
,
data3 as(
select login_time1,usr_id,login_time2 from data2 where login_time1+1=login_time2 order by login_time1
)
,
datab as(
select login_time1,count(login_time1) b from data2 group by login_time1 order by login_time1
)
 select t1.login_time1 login_date, a/b T1_retention_rate from datab t1 left join 
(selectlogin_time1,count(*) a from data3 group by login_time1 order by login_time1) t2
on
t1.login_time1=t2.login_time1