排名

用户解题统计

过去一年提交了

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

收藏

收藏日期 题目名称 解决状态
2025-12-19 海王发红包  已解决
2025-12-18 小结-行转列，展开学生成绩（1）  已解决

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-12-22 替换空格  
select replace(singer_name,' ','') as new_singer_name
from singer_info
2025-12-22 美狗计  
select replace(song_name,'人','狗') as new_song_name
from song_info
where song_name like '%人%'
2025-12-22 名字中字母e左起小于等于3位的歌手  
select singer_name,
	case when locate('e',singer_name) in (1,2,3)then 1 else 0 end as if_e_lessthan3
from singer_info
2025-12-22 找出与X轴交点大于0的一元一次函数  
select * from numbers_for_fun
where a=0 and b!=0 and b*c<0
2025-12-22 找出所有经过原点的一元一次函数  
select * from numbers_for_fun
where a= 0 and b!=0 and c =0
2025-12-22 找出所有一元一次函数  
select * from numbers_for_fun
where a= 0 and b!= 0
2025-12-22 找出所有一元一次函数  
select * from numbers_for_fun
where a= 0
2025-12-22 输出特定日期上市的银行  
select * from stock_info
where industry = '银行'
and list_date between '2006-06-01' and '2006-09-01'
2025-12-22 A和K之间的手牌（3）  
select * from hand_permutations
where (card1 between 'A' and 'K') and (card2 between 'A' and 'K')
2025-12-22 A和K之间的手牌（2）  
select * from hand_permutations
where (card1 between 'A' and 'K') or (card2 between 'A' and 'K')
2025-12-22 A和K之间的手牌（1）  
select * from hand_permutations
where card1 between 'A' and 'K'
2025-12-22 交易金额在5000至10000（含边界）的所有交易  
select * from cmb_usr_trx_rcd
where trx_amt between 5000 and 10000
order by trx_amt desc
limit 5;
2025-12-22 交易金额大于10000元的所有交易  
select * from cmb_usr_trx_rcd
where trx_amt > 100000
order by trx_amt desc;
2025-12-22 交易金额大于10000元的所有交易  
select * from cmb_usr_trx_rcd
where trx_amt > 10000
order by trx_amt desc;
2025-12-22 性别已知的听歌用户  
select * from qqmusic_user_info
where (gender = 'm' or gender = 'f') and year(birth_date) = 1980
2025-12-22 21世纪上市的银行  
select * from stock_info
where industry = '银行' and list_date like '20%'
order by list_date
2025-12-22 输出地区为北京的所有银行  
select * from stock_info
where area = '北京' and industry = '银行'
order by list_date;
2025-12-22 1989年12月13日出生的女歌手  
select * from singer_info
where birth_date = '1989-12-13'
2025-12-22 找出所有港台歌手  
select * from singer_info
where type2 = '港台'
2025-12-22 找出所有港台乐队  
select * from singer_info
where type2 = '港台' and type3 = '乐队'
order by singer_id;