排名

用户解题统计

过去一年提交了

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

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

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-10-13 与X轴有且只有一个交点的一元二次函数  
select * from numbers_for_fun
where a<>0
and b*b-4*a*c=0
order by id;
2026-10-13 与X轴有且只有一个交点的一元二次函数  
select * from numbers_for_fun
where a<>0
and b=0
and c=0
order by id;
2026-10-13 开口向上且经过原点的一元二次函数  
select * from numbers_for_fun 
where a>0
and c=0
order by id;
2026-10-13 必过(3, -8)的一元一次函数  
select * from numbers_for_fun
where 
a=0
and (3*b+c)=-8
and b<>0
order by id;
2026-10-13 不经过第三象限的一元一次函数  
select * from numbers_for_fun 
where a=0 and b<0 and c>=0
order by id;
2026-10-13 不经过第三象限的一元一次函数  
select * from numbers_for_fun 
where a=0 and b<0 and c>0
order by id;
2026-10-13 特定渠道的中档单价用户  
select * from apple_pchs_rcd
where order_channel='官网'
 and payment_method='Apple Pay'
 and product_price>=3000
 order by order_id;
2026-10-13 文科潜力股  
select * from scores
where exam_date='2024-06-30'
 and subject in('历史','政治','地理')
 and score>=90
 order by score desc,student_id,subject;
2026-10-13 给英语成绩中上水平的学生拔尖  
select * from scores
where exam_date='2024-06-30'
and subject='英语'
and score between 100 and 110
order by score desc;
2026-10-13 找出三个班级的女生  
select * from students
where gender='f'
and class_code in ('C219','C220','C221')
order by student_id;
2026-10-13 找出三个班级的女生  
select * from students
where gender='m'
and class_code in ('C219','C220','C221')
order by student_id;
2026-10-13 大于J小于K的手牌  
select *
from hand_permutations
where
	card1>'J' AND card1<'K'
AND
card2>'J' AND card2<'K';
2026-10-13 2000年以前出生的男歌手  
select * from singer_info 
where birth_date>2000-01-01 and gender='m';
2026-10-13 总分超过300分的学生  
select student_id
from subject_score 
where chinese+math+english>=300;
2026-10-13 国庆假期后第一天涨幅高于1%的股票  
select ts_code,open_price,close_price
from daily_stock_prices
where trade_date='2023-10-09'
and pct_change>1;
2026-10-13 德州扑克起手牌-最强起手牌KK+  
select * 
from hand_permutations 
where (card1 like 'A_' AND card2 LIKE 'A_')
or (card1 like 'A_' AND card2 LIKE 'K_')
OR (card1 LIKE 'K_' AND card2 LIKE 'K_')
OR (card1 LIKE 'K_' AND card2 LIKE 'A_');
2026-10-11 S1年级物理成绩前10名（2）  
select student_id,name,score,rnk
from
(select st.student_id,st.name,sc.score,
rank()over(order by sc.score desc) rnk
from students st
join scores sc
on st.student_id=sc.student_id
where st.grade_code='S1'
and sc.subject='物理') as ranked_scores
where rnk<10;
2026-10-11 S1年级物理成绩前10名（1）  
select student_id,name,score,rnk
from (select st.student_id,st.name,sc.score,
row_number()over(PARTITION BY st.grade_code order by sc.score desc) rnk
from students st
join scores sc
on st.student_id=sc.student_id
where subject='物理' and grade_code='S1') as ranked_scores
where rnk<=10
order by rnk,student_id;
2026-10-11 人数最多的学生姓氏  
select substr(name,1,1) first_name,count(*) cnt
from students
group by first_name
order by cnt desc
limit 5;
2026-10-11 学生信息和班主任姓名  
select s.name,s.class_code,s.grade_code,t.name head_teacher
from students s
join teachers t
on s.class_code=t.head_teacher
order by student_id;