排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-06-19 北京有雪的日子  
select dt, tmp_h, tmp_l, con from weather_rcd_china
where city = 'beijing' and con like '%雪%'
2025-06-19 条件过滤-查找1994年至1997年毕业的女教师  
select name, subject, class_code, graduate_date from teachers
where gender = 'f' and year(graduate_date) between '1994' and '1997'
order by graduate_date
2025-06-19 条件过滤-符合条件的班主任  
select name, subject, class_code,qualification from teachers
where fir_degr = '清华大学' or fir_degr = '北京大学' and head_teacher is not null
order by name
2025-06-19 条件过滤-符合条件的班主任  
select name, subject, class_code,qualification from teachers
where fir_degr = '清华大学' or fir_degr = '北京大学'
order by name
2025-06-19 查询所有起点或终点为“海底捞西丽店”的行程记录  
select * from didi_sht_rcd
where start_loc = '海底捞西丽店' or end_loc = '海底捞西丽店'
2025-06-16 经过3个象限的一元一次函数  
select * from numbers_for_fun where
    a = 0 and b<>0 and c<>0
2025-06-16 经过至少两个象限的一元一次函数  
select * from numbers_for_fun
where
	a = '0' and b != '0' and c != 0
2025-06-16 经过至少两个象限的一元一次函数  
select * from numbers_for_fun
where
	a = '0' and b != '0'
2025-06-13 一元一次函数形成的三角形面积  
SELECT *
FROM numbers_for_fun
WHERE a = 0
AND 0.5 * ABS(c * c / b) >= 5;
2025-06-13 一元一次函数形成的三角形面积  
SELECT *
FROM numbers_for_fun
WHERE a = 0
AND ABS(c)*ABS(c) >= 10 * ABS(b);
2025-06-13 一元一次函数形成的三角形面积  
select * from numbers_for_fun
WHERE a = 0 AND ABS(c * (ABS(c / b) + c) / 2) >= 5
2025-06-13 一元一次函数形成的三角形面积  
select * from numbers_for_fun
where 
	a = 0 and (b <= (c*c/(10-c*c)) or b >= (c*c/(c*c-10)))
2025-06-13 一元一次函数形成的等腰三角形  
select * from numbers_for_fun
where a = '0' and (b = '1' or b = '-1') and c != '0'
order by id
2025-06-12 一元一次函数形成的等腰三角形  
select * from numbers_for_fun 
where
	a = '0' and b = '-1'
order by
id
2025-06-11 与X轴有且只有一个交点的一元二次函数  
select * from numbers_for_fun 
where a != '0' and b*b = 4*a*c
order by id
2025-06-11 开口向上且经过原点的一元二次函数  
select * from numbers_for_fun 
where
	a > '0' and c = '0'
2025-06-11 开口向上的一元二次函数  
select * from numbers_for_fun
where
	a > '0'
order by
	id
2025-06-11 必过(-1, 0)的一元一次函数  
select * from numbers_for_fun
where
	a = '0' and b != '0' and c = b
order by
	id
2025-06-10 必过(3, -8)的一元一次函数  
select * from numbers_for_fun
where
	a = '0' and b != '0' and c = -3*b - 8
order by id
2025-06-10 必过(-1, -1)的一元一次函数  
select * from numbers_for_fun
where
	a = '0' and b != '0' and c = b - 1
order by
	id