排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-02-23 分组与聚合函数（5）想知道何时成瘾，用Max Or Min？  
SELECT 
	usr_id, trx_time as first_time ,mch_nm
FROM 
	cmb_usr_trx_rcd 
WHERE 
	usr_id = '5201314520'
AND 
	mch_nm = '红玫瑰按摩保健休闲'
ORDER BY 
	first_time ASC
LIMIT 1;
2026-02-23 分组与聚合函数（5）想知道何时成瘾，用Max Or Min？  
SELECT 
	usr_id, min(trx_time) as first_time ,mch_nm
FROM 
	cmb_usr_trx_rcd 
WHERE 
	usr_id = '5201314520'
AND 
	mch_nm = '红玫瑰按摩保健休闲'
ORDER BY 
	first_time ASC
LIMIT 1;
2026-02-23 分组与聚合函数（5）想知道何时成瘾，用Max Or Min？  
SELECT 
	usr_id,trx_time AS first_time,mch_nm
FROM 
	cmb_usr_trx_rcd 
WHERE 
	usr_id = 5201314520
AND 
	mch_nm = '红玫瑰按摩保健休闲'
ORDER BY 
	first_time DESC
LIMIT 1;
2026-02-23 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
SELECT 
mch_nm, 
SUM(trx_amt) AS sum_trx_amt
FROM 
 	cmb_usr_trx_rcd 
WHERE 
	usr_id = 5201314520
AND 
	year(trx_time) = 2024
GROUP BY 
	mch_nm;
2026-02-23 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
SELECT 
mch_nm, 
SUM(trx_amt) AS sum_trx_amt
FROM cmb_usr_trx_rcd 
WHERE usr_id = 5201314520
AND trx_time LIKE '2024%'
GROUP BY mch_nm;