排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-01-06 特定歌曲的播放记录  
select * from listen_rcd 
where 
 song_id='13'
 and date(start_time) between '2023-12-10' and '2023-12-31'
 order by start_time
2026-01-06 特定歌曲的播放记录  
select * from listen_rcd 
where 
 song_id='3'
 and date(start_time) between '2023-12-10' and '2023-12-31'
 order by start_time
2026-01-06 渣男腰子可真行，端午中秋干不停  
select * from cmb_usr_trx_rcd 
where 
 usr_id='5201314520'
 and(date(trx_time) between '2024-06-08'and '2024-06-10'
or date(trx_time) between '2024-09-15'and '2024-09-17' )
order by trx_time
2026-01-06 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where usr_id=5201314520
	and (hour(trx_time) >='22' or hour(trx_time) <='5')
and date(trx_time) between'2024-09-01' and '2024-09-30'
order by trx_time
2026-01-06 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd 
where 
	usr_id='5201314520'
	AND date(trx_time) between '2024-09-01' and '2024-09-30'
	and hour(trx_time) between 1 and 5
order by trx_time
2026-01-06 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id='5201314520'and trx_time between '2024-09-01 ' and '2024-10-01'
order by trx_time
2026-01-06 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id='5201314520'and trx_time between '2024-09-01 ' and '2024-09-30'
order by trx_time
2026-01-06 S1年级物理成绩前10名（2）  
with scores_ranks as(
select s.student_id,s.name,sc.score,rank() over(order by sc.score desc) as ranking
from students s 
join scores sc on s.student_id=sc.student_id
	where sc.subject="物理"and s.grade_code='S1'
)
select student_id,name,score, ranking
from scores_ranks
whereranking <=10
order by ranking
2026-01-04 S1年级物理成绩前10名（1）  
with ranked_scores as (
select s.student_id,s.name,scores.score,row_number()over(partition by s.grade_code order by scores.score desc) as rnk
from students s
join scores on scores.student_id=s.student_id
where s.grade_code = 'S1'and scores.subject = '物理'
)
select student_id,name,score,rnk
from ranked_scores
where rnk<=10
order by rnk,student_id
2026-01-04 S1年级物理成绩前10名（1）  
with ranked_scores as (
select s.student_id,s.name,scores.score,row_number()over(partition by s.grade_code order by scores.score desc) as rnk
from students s
join scores on scores.student_id=s.student_id
where s.grade_code = 'S1'and scores.subject = '物理'
)
select student_id,name,score,rnk
from ranked_scores
where rnk<=10
ORDER BY 
    rnk,student_id
2026-01-04 人数最多的学生姓氏  
select left(name,1),count(*) 
from students 
group by left(name,1)
order by count(*) desc
limit 5
2026-01-04 人数最多的学生姓氏  
select left(name,1),count(*) 
from students 
group by left(name,1)
order by count(*) desc
2026-01-04 查询所有终点是餐饮类地点的行程记录  
select dsr.*
from didi_sht_rcd dsr
join loc_nm_ctg lnc on dsr.end_loc=lnc.loc_nm
where lnc.loc_ctg like '%餐饮%'
order by dsr.start_tm
2026-01-04 学生信息和班主任姓名  
select students.name,students.class_code,students.grade_code,teachers.name as header_name
from students 
join teachers on students.class_code=teachers.head_teacher
where students.class_code=teachers.head_teacher
 orderby students.student_id
2025-12-22 学生信息和班主任姓名  
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-12-22 学生信息和班主任姓名  
select students.name,students.class_code,students.grade_code,teachers.name
from students 
 join teachers on students.class_code=teachers.class_code
 order by students.student_id
2025-12-22 学生信息和班主任姓名  
select students.name,students.class_code,students.grade_code,teachers.name
from students 
 join teachers on students.class_code=teachers.class_code
where students.class_code=teachers.head_teacher
 order by students.student_id
2025-12-22 学生信息和班主任姓名  
select students.name,students.class_code,students.grade_code,teachers.name
from students 
left join teachers on students.class_code=teachers.class_code
where students.class_code=teachers.head_teacher
 order by students.student_id