排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-03-30 人数最多的学生姓氏  
select left(name,1)as surname,
count(*) cnt
from students
group by
surname
order by
cnt desc
limit 5
2026-03-30 人数最多的学生姓氏  
select left(name,1)as surname,
count(*) cnt
from students
group by
surname
order by
cnt desc
2026-03-30 学生信息和班主任姓名  
select s.name,s.class_code,s.grade_code,t.name as head_teacher_name
 from students s
join teachers t on s.class_code =t.head_teacher
order by s.student_id
2026-03-30 学生信息和班主任姓名  
select s.name,s.class_code,t.name as head_teacher_name,
s.grade_code from students s
join teachers t on s.class_code =t.head_teacher
order by s.student_id
2026-03-30 学生信息和班主任姓名  
select s.name,s.class_code,t.name as head_teacher_name,
s.grade_code from students s
join teachers t on s.class_code =t.head_teacher
2026-03-30 学生信息和班主任姓名  
select s.name,s.class_code,t.name as teacher_name,
s.grade_code from students s
join teachers t on s.class_code =t.head_teacher
2026-03-30 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where usr_id=5201314520
and (date(trx_time) between '2024-9-1' and '2024-9-30'
and hour(trx_time) between 22 and 24
or hour(trx_time) between 0 and 5)
order by trx_time;
2026-03-30 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where usr_id=5201314520
and date(trx_time) between '2024-9-1' and '2024-9-30'
and hour(trx_time) between 22 and 24
or hour(trx_time) between 0 and 5
order by trx_time;
2026-03-30 条件过滤（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
2026-03-30 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select * from cmb_usr_trx_rcd
where usr_id =5201314520 and
(date(trx_time) between '2024-09-01'and '2024-09-30'and 
hour(trx_time)between '1' and '5')
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id = 5201314520
and date(trx_time) between '2024-9-01' and '2024-9-30'
order by trx_time
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id = 5201314520
and trx_time between '2024-9-01' and '2024-9-30'
order by trx_time
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id = 5201314520
and trx_time between '2024-9-01' and '2024-9-30'
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id = 5201314520
and trx_time between '024-9-01' and '2024-9-30'
order by trx_timedesc
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd 
where usr_id=5201314520
and trx_time between '024-9-01' and '2024-9-30'
2026-03-30 德州扑克起手牌-最强起手牌KK+  
select *
from hand_permutations 
where (card1 like "A%" or card1 like "K%") 
and (card2 like "A%" or card2 like "K%") 
order by id;
2026-03-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
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * 
from cmb_usr_trx_rcd
where usr_id ='5201314520'
and 
(trx_time between '2024-09-01'and '2024-09-30')
order by
 trx_time
2026-03-30 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * from cmb_usr_trx_rcd
where usr_id ='5201314520'and 
trx_time between '2024-09-01'and '2024-09-30'
order by
 trx_time