排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-03-04 销售金额前10的商品信息  
select 
	goods_id,
sum(order_gmv) as total_gmv
from 
	order_info 
where date(order_time) = "2024-09-10 00:00:00" 
group by goods_id
order by total_gmv desc
limit 10;
2026-02-12 与X轴有且只有一个交点的一元二次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    b*b - 4*a*c = 0 and a<>0
order by id
2026-02-12 开口向上且经过原点的一元二次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a>0 and a*0+b*0+c=0
order by id
2026-02-12 必过(3, -8)的一元一次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a=0 and (3*b+c)= -8 and b<>0
order by id
2026-02-12 不经过第三象限的一元一次函数  
select 
    * 
from 
    numbers_for_fun 
where 
    a=0 and b<0 and c>=0
order by id;
2026-02-12 特定渠道的中档单价用户  
select * from apple_pchs_rcd 
where order_channel="官网" and payment_method="Apple Pay" and product_price >=3000;
2026-02-12 特定渠道的中档单价用户  
select * from apple_pchs_rcd 
where payment_method="Apple Pay" and product_price >=3000;
2026-02-12 文科潜力股  
select * from scores 
where exam_date ="2024-06-30" and (
(subject="历史" and score >=90 )
or (subject="政治" and score >=90)
or (subject="地理" and score >=90)
) order by score desc,student_id,subject ;
2026-02-12 文科潜力股  
select * from scores 
where exam_date ="2024-06-30" and (subject="历史" and score >90 
or subject="政治" and score >90
or subject="地理" and score >90) order by score desc,student_id,subject ;
2026-02-12 文科潜力股  
select * from scores 
where exam_date ="2024-06-30" and (subject="历史" or subject="政治" or subject="地理" ) and score >90;
2026-02-12 给英语成绩中上水平的学生拔尖  
select * from scores 
where exam_date ="2024-06-30" and subject="英语" and score between 100 and 110 order by score desc;
2026-02-12 给英语成绩中上水平的学生拔尖  
select * from scores 
where exam_date ="2024-06-30" and score between 100 and 110 order by score desc;
2026-02-12 找出三个班级的女生  
select * from students 
where class_code in ("C219","C220","C221") and gender ="f" order by student_id;
2026-02-12 找出三个班级的女生  
select * from students 
where class_code in ("C219","C220","C221") and gender ="m" order by student_id;
2026-02-12 大于J小于K的手牌  
select * from hand_permutations 
where card1 > "J" and card1<"K" and card2 > "J" and card2<"K";
2026-02-12 2000年以前出生的男歌手  
select * from singer_info 
where gender = "m" and birth_date<"2000-01-01";
2026-02-12 2000年以前出生的男歌手  
select * from singer_info 
where gender = "f" and birth_date<"2000-01-01";
2026-02-12 2000年以前出生的男歌手  
select * from singer_info 
where gender = "f" and substr(birth_date,0,3)<2000;
2026-02-12 2000年以前出生的男歌手  
select * from singer_info 
where gender = "f" and substr(birth_date,1,4)<2000;
2026-02-12 总分超过300分的学生  
select student_id from subject_score 
where chinese+english+math >=300;