排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
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