排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-01-22 不分类别的最火直播间 
selecta.live_id,ks_live_t2.live_nm,a.count
from
(selectks_live_t1.live_id,count(ks_live_t1.usr_id) as count from ks_live_t1
where date_format(ks_live_t1.enter_time,'%Y-%m-%d %H')='2021-09-12 23' 
group by ks_live_t1.live_id
order by count desc
limit 5) as a
left join ks_live_t2 on a.live_id=ks_live_t2.live_id;
2025-01-22 不分类别的最火直播间 
selecta.*,ks_live_t2.live_nm
from
(selectks_live_t1.live_id,count(ks_live_t1.usr_id) as count from ks_live_t1
where date_format(ks_live_t1.enter_time,'%Y-%m-%d %H')='2021-09-12 23' 
group by ks_live_t1.live_id
order by count desc
limit 5) as a
left join ks_live_t2 on a.live_id=ks_live_t2.live_id;
2025-01-22 不分类别的最火直播间 
selecta.*,ks_live_t2.live_nm
from
(selectks_live_t1.live_id,count(ks_live_t1.usr_id) as count from ks_live_t1
where ks_live_t1.enter_time<='2021-09-12 23:00:00' 
	and ks_live_t1.leave_time>'2021-09-12 23:00:00'
group by ks_live_t1.live_id
order by count desc
limit 5) as a
left join ks_live_t2 on a.live_id=ks_live_t2.live_id;
2025-01-22 绘制小时进入人数曲线 
select 
lpad(hour(enter_time),2,'0') as hour,
count(usr_id)
from ks_live_t1
group by hour
order by hour asc
2025-01-22 绘制小时进入人数曲线 
select 
lpad(hour(enter_time),2,'0') as hour,
count(usr_id)
from ks_live_t1
group by
hour
2025-01-22 绘制小时进入人数曲线 
select hour(enter_time) as hour,count(usr_id) from ks_live_t1 group by hour(enter_time)
2025-01-22 德州扑克起手牌-同花 
select * from hand_permutations
where right(card1,1)=right(card2,1)
2025-01-22 德州扑克起手牌- 手对 
select * from hand_permutations
where char_length(card1)=char_length(card2) and left(card1,1)=left(card2,1)
2025-01-22 德州扑克起手牌- A花 
select * from hand_permutations 
where (left(card1,1)="A" or left(card2,1)="A")
		and 
(right(card1,1)=right(card2,1));
2025-01-22 德州扑克起手牌- A花 
select * from hand_permutations where left(card1,1)="A"
2025-01-22 德州扑克起手牌- A花 
select * from hand_permutations where left(card1,1)="A" or left(card2,1)="A"
2025-01-22 德州扑克起手牌-最强起手牌KK+ 
select * from hand_permutations where left(card1,1) in ("A","K") and left(card2,1) in ("A","K");
2025-01-21 抖音面试真题(1)T+1日留存率 
with data1 as (
select distinct
 date(DATE_ADD(login_time,interval 1 day)) as T_before1,
 date(login_time) as T_org,
 usr_id 
 from user_login_log
where datediff(current_date, date(login_time)) <= 30),
 data2 as (
 select distinct
 date(login_time) as T_org,
 usr_id
 from user_login_log
 ),
 data3 as (
 select 
 data1.T_org,
 data1.usr_id,
 case 
 when data2.T_org is null
 then 0
 else 1
 end as count_T
 from 
 data1 
 left join data2 on data1.T_before1=data2.T_org and data1.usr_id=data2.usr_id)
 select 
 data3.T_org,
 concat(round((sum(data3.count_T)/count(data3.usr_id))*100,2),"%") as T1_retention_rate
 from data3
 group by data3.T_org
 order by data3.T_org asc
2025-01-13 德州扑克起手牌-最强起手牌KK+ 
select *
from hand_permutations
where 
    concat(card1, card2) like '%A%A%' or
    concat(card1, card2) like '%A%K%' or
    concat(card1, card2) like '%K%K%' or
    concat(card1, card2) like '%K%A%'
order by id;
2025-01-13 人数最多的学生姓氏 
select left(name,1) as last_name,count(*) as num from students
group by last_name order by num desc limit 5
2025-01-13 学生信息和班主任姓名 
select students.name,students.class_code,students.grade_code,teachers.name from students join teachers on students.class_code=teachers.head_teacher
order by students.student_id;
2025-01-13 热门搜索关键词 
select key_word,count(key_word) as search_num from jx_query_rcd group by key_word
order by search_num desc
limit 5;
2025-01-12 热门搜索关键词 
SELECT 
    key_word,
    COUNT(*) AS search_count
FROM jx_query_rcd
GROUP BY key_word
ORDER BY search_count desc
LIMIT 5;
2025-01-12 热门搜索关键词 
SELECT 
    key_word,
    COUNT(*) AS search_count
FROM jx_query_rcd
GROUP BY key_word
ORDER BY search_count
LIMIT 5;
2025-01-12 曝光量最大的商品 
select a.prd_id,b.prd_nm,a.exposure_count
from
(select prd_id, sum(if_snd) as exposure_count from tb_pg_act_rcd
 group by prd_id ) a
join tb_prd_map b on a.prd_id=b.prd_id 
order by exposure_count desc limit 1