排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

评论日期 题目名称 评论内容 站长评论
2026-01-12 给英语成绩中上水平的学生拔尖  
between 写错了
 
啥也没说

提交记录

提交日期 题目名称 提交代码
2026-01-13 基于共同兴趣爱好的餐厅推荐（1）-我吃过啥  
select distinct
cust_uid,mch_nm
from mt_trx_rcd1 
where cust_uid='MT10000'
2026-01-13 HAVING-语数英优异的学生  
select 
student_id,sum(score) total_score
from scores 
where exam_date ='2024-06-30' and subject in ('语文','数学','英语')
group by student_id
having total_score>330
2026-01-13 HAVING-语数英优异的学生  
select 
student_id,sum(score) total_score
from scores 
where exam_date ='2024-06-30'
group by student_id
having total_score>330
2026-01-13 HAVING-语数英优异的学生  
select 
student_id,sum(score) total_score
from scores 
group by student_id
having total_score>330
2026-01-13 HAVING-执教教师超过3人的科目  
select 
	subject
from teachers
group by subject
having count(teacher_id)>=3
2026-01-13 HAVING-每次成绩都不低于80分的学生  
select 
	student_id,
max(score) max_score,
min(score) min_score,
	avg(score) avg_score
from scores 
group by student_id
having min_score >=80
order by student_id
2026-01-13 HAVING-每次成绩都不低于80分的学生  
select 
	student_id,
max(score) max_score,
min(score) min_score,
	avg(score) avg_score
from scores 
group by student_id
having avg_score >=80
order by student_id
2026-01-13 HAVING-每次成绩都不低于80分的学生  
select 
	student_id,
max(score) max_score,
min(score) min_score,
	sum(score)/count(score) avg_score
from scores 
group by student_id
having avg_score >=80
order by student_id
2026-01-13 GROUP BY-年龄最大学生的出生日期  
select class_code,min(birth_date) min_birth_date
from students 
group by class_code 
order by class_code
2026-01-13 GROUP BY-各科目最高分、最低分  
select subject,max(score) max_score,min(score) min_score 
from scores 
group by subject
order by subject
2026-01-13 GROUP BY-各科目平均分  
select subject,avg(score) average_score from scores 
where exam_date = '2024-06-30'
group by subject 
order by subject desc
2026-01-13 GROUP BY-各科目平均分  
select subject,avg(score) average_score from scores 
group by subject
2026-01-13 GROUP BY-各班级人数  
SELECT class_code,count(student_id) student_count
FROM students 
GROUP BYclass_code
having student_count > 10
order by student_count desc
2026-01-13 GROUP BY-各班级人数  
SELECT class_code,count(student_id) student_count
FROM students 
GROUP BY grade_code, class_code
having student_count > 10
order by student_count desc
2026-01-13 GROUP BY-各班级人数  
SELECT class_code,count(1) student_count
FROM students 
GROUP BY grade_code, class_code
order by student_count desc
2026-01-13 GROUP BY-各班级人数  
SELECT class_code,count(1) student_count
FROM students 
GROUP BY grade_code, class_code
2026-01-13 按照车类统计行程次数  
select car_cls,sum(1) trip_count from didi_sht_rcd
group by car_cls 
order by trip_count desc
2026-01-13 多云天气天数  
select
	city,
sum(case 
	when con regexp '多云' then 1
	else 0
end
 ) cloudy_days,
concat(
	cast(
	sum(
	case 
		when con regexp '多云' then 1
		else 0
		end
 		)/count(1)
	*100
as decimal(10,2)
),
	'%'
)p
from weather_rcd_china
where year(dt)= 2021
group by city
2026-01-13 分类（1）姿势太多很过分，分类要用CaseWhen  
select 
	case 
	when trx_amt = 288 then '1.WithHand'
when trx_amt = 388 then '2.WithMimi'
when trx_amt = 588 then '3.BlowJobbie'
when trx_amt = 888 then '4.Doi'
when trx_amt = 1288 then '5.DoubleFly'
else '6.other'
end ser_typ,
	count(1) trx_cnt,
	min(date(trx_time)) first_date
from cmb_usr_trx_rcd 
where 
	usr_id = '5201314520' 
and mch_nm = '红玫瑰按摩保健休闲'
group by ser_typ
order by 1
2026-01-13 分类（1）姿势太多很过分，分类要用CaseWhen  
select 
	case 
	when trx_amt = 288 then '1.WithHand'
when trx_amt = 388 then '2.WithMimi'
when trx_amt = 588 then '3.BlowJobbie'
when trx_amt = 888 then '4.Doi'
when trx_amt = 1288 then '5.DoubleFly'
else '6.other'
end ser_typ,
	count(1) trx_cnt,
	min(trx_time) first_date
from cmb_usr_trx_rcd 
where 
	usr_id = '5201314520' 
and mch_nm = '红玫瑰按摩保健休闲'
group by ser_typ
order by 1