排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-04-03 A和K之间的手牌（2）  
select * from hand_permutations 
where card1 between 'A' and 'K'
or card2 between 'A' and 'K'
order by id
2025-04-03 A和K之间的手牌（2）  
select * from hand_permutations 
where card2 between 'A' and 'K'
order by id
2025-04-03 A和K之间的手牌（1）  
select * from hand_permutations 
where card1 between 'A' and 'K' 
order by id
2025-04-03 A和K之间的手牌（1）  
select * from hand_permutations 
where left(card1,1) between 'A' and 'K' 
order by id
2025-04-03 A和K之间的手牌（1）  
select * from hand_permutations 
where left(card1,1) between 'A' and 'K'
2025-04-03 交易金额在5000至10000（含边界）的所有交易  
select * from cmb_usr_trx_rcd 
where trx_amt between 5000 and 10000
order by trx_amt desc 
limit 5
2025-04-03 交易金额大于10000元的所有交易  
select * from cmb_usr_trx_rcd 
where trx_amt > 100000
order by trx_amt desc
2025-04-03 大于J小于K的手牌  
select 
    * 
from 
    hand_permutations
where 
    card1 > 'J'  and card1 < 'K'
    and 
     card2 > 'J'  and card2 < 'K'
2025-04-03 大于J小于K的手牌  
select * from hand_permutations 
where left(card1,1)='Q'
and left(card2,1)='Q'
order by id
2025-04-03 语文数学英语至少1门超过100分的同学  
select * from subject_score 
where chinese > 100
or math >100
or english > 100
order by chinese
2025-04-02 性别已知的听歌用户  
select * from qqmusic_user_info 
where gender in ('m','f')
and year(birth_date) = 1980
order by birth_date
2025-04-02 2000年以前出生的男歌手  
select * from singer_info 
where year(birth_date) <2000
and gender = 'm'
2025-04-02 21世纪上市的银行  
select * from stock_info 
where year(list_date) >= 2000
and industry = '银行'
order by list_date
2025-04-02 输出地区为北京的所有银行  
select * from stock_info 
where area = '北京'
and industry = '银行'
order by list_date
2025-04-02 1989年12月13日出生的女歌手  
select * from singer_info
where birth_date = '1989-12-13'
and gender = 'f'
2025-04-02 找出所有港台歌手  
select * from singer_info
where type2 = '港台'
order by singer_id
2025-04-02 找出所有港台乐队  
select * from singer_info 
where type2 = '港台'
and type3 = '乐队'
order by singer_id
2025-04-02 找出所有港台乐队  
select * from singer_info 
where type2 = '港台'
order by singer_id
2025-04-02 海王发红包  
select distinct snd_usr_id
from 
(
select snd_usr_id
,sum(case when pkt_amt in (520,200) then 1 else 0 end) sum
from tx_red_pkt_rcd
group by snd_usr_id
having sum >= 5
) a
order by snd_usr_id
2025-04-02 接收红包金额绿茶榜  
select rcv_usr_id
,sum(pkt_amt) sum 
from tx_red_pkt_rcd
where rcv_datetime != '1900-01-01 00:00:00'
group by rcv_usr_id
order by sum desc
limit 10