排名

用户解题统计

过去一年提交了

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

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

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-08-17 学生信息和班主任姓名  
select
s.name,
s.class_code,
s.grade_code,
t.name as head_teacher_name
from students s
join teachers t on s.class_code=t.head_teacher
order by s.student_id asc
;
2026-08-17 学生信息和班主任姓名  
select
s.name,
s.class_code,
s.grade_code,
t.name as head_teacher_name
from students s
join teachers t on s.class_code=t.head_teacher
order by s.student_id asc
limit 5;
2026-08-17 学生信息和班主任姓名  
select
s.name,
s.class_code,
s.grade_code,
t.name as head_teacher
from students s
join teachers t on s.class_code=t.head_teacher
order by s.student_id asc
limit 5;
2026-08-17 学生信息和班主任姓名  
select 
s.name,s.student_id,
s.grade_code,
t.name as head_teacher
from students s
join teachers t on s.class_code=t.head_teacher
order by student_id asc
limit 5;
2026-08-17 学生信息和班主任姓名  
select s.student_id,
s.name,
s.grade_code,
t.name as head_teacher
from students s
join teachers t on s.class_code=t.head_teacher
order by student_id asc
limit 5;
2026-08-17 S1年级物理成绩前10名（2）  
with score_rank as (
select s.student_id,
s.name,
sc.score,
rank() over(partition by s.grade_code order by sc.score desc) as rnk
from students s
join scores sc on s.student_id=sc.student_id
where s.grade_code='S1' and sc.subject='物理')
select student_id,
name,
score,
rnk
from score_rank sr
where rnk<=10
order by rnk,student_id;
2026-08-17 S1年级物理成绩前10名（1）  
with score_rank as (
select s.student_id,
s.name,
sc.score,
row_number() over(partition by s.grade_code order by sc.score desc) as rnk
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,
rnk
from score_rank sr
where rnk<=10
order by rnk,student_id;
2026-08-17 S1年级物理成绩前10名（1）  
with score_rank as (
select sc.student_id,sc.score,row_number() over(order by sc.score desc) as rnk
from scores sc
join students s on sc.student_id=s.student_id
where sc.subject='物理' and s.grade_code='S1')
select s.student_id,s.name,sr.score,sr.rnk
from score_rank sr
join students s on sr.student_id=s.student_id
where sr.rnk<=10;
2026-08-15 S1年级物理成绩前10名（1）  
with ph_rank as (
select student_id,rank() over(order by score desc) as rnk
from scores
where subject='物理')
select s.student_id,s.name
from students s
join ph_rank pr on s.student_id=pr.student_id
where s.grade_code='S1' and pr.rnk<=10;
2026-08-15 人数最多的学生姓氏  
select left(name,1) as left_name,
count(*) as num
from students 
group by left_name
order by num desc
limit 5;