排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-12-31 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
select mch_nm,sum(trx_amt) sum_trx_amt from cmb_usr_trx_rcd
where 
	usr_id = '5201314520' 
and 
	year(trx_time) = 2024 
group by mch_nm
order by sum(trx_amt);
2025-12-31 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
select mch_nm,sum(trx_amt) sum_trx_amt from cmb_usr_trx_rcd
where 
	usr_id = '5201314520' 
and 
	year(trx_time) = 2024 
group by mch_nm 
order by sum(trx_time);
2025-12-31 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
select 
	mch_nm , sum(trx_amt) sum_trx_amt from cmb_usr_trx_rcd 
where usr_id = '5201314520' 
	and year(trx_time) = 2024 
group by mch_nm
order by mch_nm,sum(trx_amt);
2025-12-31 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
select mch_nm, sum(trx_amt) 
from cmb_usr_trx_rcd
where usr_id = '5201314520'
and year(trx_time) = 2024
group by mch_nm 
order by mch_nm, sum(trx_amt);
2025-12-31 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where 
	date(trx_time) between '2024-09-01' and '2024-09-30'
and ( 
hour(trx_time) >= 22 
or 
hour(trx_time) between 0 and 5
)
and usr_id = '5201314520'
order by trx_time;
2025-12-31 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where 
	date(trx_time) between '2024-09-01' and '2024-09-30'
and ( 
(hour(trx_time) >= 22) 
or 
(hour(trx_time) between 0 and 5)
)
and usr_id = '5201314520'
order by trx_time;
2025-12-31 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where 
	date(trx_time) between '2024-09-01' and '2024-09-30'
and ( 
(hour(trx_time) >= 22) 
or 
(hour(trx_time) between 1 and 5)
)
and usr_id = '5201314520'
order by trx_time;
2025-12-31 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where 
	date(trx_time) between '2024-09-01' and '2024-09-30'
and (hour(trx_time) >= 22 
or hour(trx_time) between 1 and 5 )
and usr_id = '5201314520'
order by trx_time;
2025-12-31 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where 
	date(trx_time) between '2024-09-01' and '2024-09-30'
and (hour(trx_time) between 22 and 24
or hour(trx_time) between 1 and 5 )
and usr_id = '5201314520'
order by trx_time;
2025-12-31 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd
where 
	date(trx_time) between '2024-09-01' and '2024-09-30'
and (hour(trx_time) between 22 and 0
or hour(trx_time) between 1 and 5 )
and usr_id = '5201314520'
order by trx_time;
2025-12-31 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select 
	usr_id,mch_nm,trx_time,trx_amt from cmb_usr_trx_rcd 
where 
	date(trx_time) 
between '2024-09-01' and '2024-09-30' 
and hour(trx_time) between 1 and 5 
and usr_id = '5201314520'
order by 
	trx_time;
2025-12-31 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select usr_id,mch_nm,trx_time,trx_amt from cmb_usr_trx_rcd 
where date(trx_time) between '2024-09-01' and '2024-09-30' 
and hour(trx_time) between 1 and 5 
 and usr_id = '5201314520';
2025-12-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where date(trx_time) between '2024-09-01' and '2024-09-30'and usr_id = '5201314520'
order by trx_time