排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

评论日期 题目名称 评论内容 站长评论
2025-01-08 大于J小于K的手牌  
输出示例直接把答案贴上来了。
 
尴尬了哈哈哈 已修改

提交记录

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