排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2025-08-11 21世纪上市的银行  
select * from stock_info where list_date >= '2000-01-01' and industry = '银行' order by list_date
2025-08-11 输出地区为北京的所有银行  
select * from stock_info 
where area = '北京' and industry = '银行'
order by list_date
2025-08-05 输出地区为北京的所有银行  
select * from stock_info where area = '北京'
 order by list_date desc
2025-08-05 输出地区为北京的所有银行  
select * from stock_info where area = '北京'
 order by list_date
2025-08-05 1989年12月13日出生的女歌手  
select * from singer_info where gender = 'f' and birth_date = '1989-12-13'
2025-08-05 找出所有港台歌手  
select * from singer_info where type2 = '港台'
2025-08-05 招建银行信用卡中心客户挽留-电商平台分类  
SELECT 
distinct mch_nm AS merchant_name,
CASE 
WHEN mch_nm LIKE '%拼多多%' THEN '拼多多'
WHEN mch_nm LIKE '%京东%' THEN '京东'
WHEN mch_nm LIKE '%淘系%' THEN '淘系'
WHEN mch_nm LIKE '%抖音%' THEN '抖音'
WHEN mch_nm LIKE '%小红书%' THEN '小红书'
ELSE '其他'
END AS platform
FROM 
ccb_trx_rcd;
2025-08-05 招建银行信用卡中心客户挽留-电商平台分类  
SELECT 
mch_nm AS merchant_name,
CASE 
WHEN mch_nm LIKE '%拼多多%' THEN '拼多多'
WHEN mch_nm LIKE '%京东%' THEN '京东'
WHEN mch_nm LIKE '%淘系%' THEN '淘系'
WHEN mch_nm LIKE '%抖音%' THEN '抖音'
WHEN mch_nm LIKE '%小红书%' THEN '小红书'
ELSE '其他'
END AS platform
FROM 
ccb_trx_rcd;
2025-08-05 招建银行信用卡中心客户挽留-电商平台分类  
select mch_nm as merchant_name , 
		case 
	when mch_nm like '%拼多多%' then '拼多多'
 			when mch_nm like '%京东%' then '京东'
when mch_nm like '%淘系%' then '淘系'
when mch_nm like '%抖音%' then '抖音'
when mch_nm like '%小红书%' then '小红书'
else '其他'
endas platform
from ccb_trx_rcd
2025-08-05 找出所有港台乐队  
select 
    * 
from 
    singer_info 
where
    type2 = '港台' and type3='乐队'
order by 
    singer_id
2025-08-05 国庆假期后第一天涨幅高于1%的股票  
SELECT 
    ts_code, 
    open_price, 
    close_price
FROM 
    daily_stock_prices
WHERE 
    trade_date = '2023-10-09' AND pct_change > 1;
2025-08-05 德州扑克起手牌-最强起手牌KK+  
select *
from hand_permutations
where 
    concat(card1, card2) like '%A%A%' or
    concat(card1, card2) like '%A%K%' or
    concat(card1, card2) like '%K%K%' or
    concat(card1, card2) like '%K%A%'
order by id;
2025-08-05 文科潜力股  
select 
    * 
from 
    scores 
where 
    (
      (subject = '历史' and score >= 90)
    or (subject = '地理' and score >= 90)
    or (subject = '政治' and score >= 90)
       )
    and exam_date='2024-06-30'
order by score desc ,student_id,subject
2025-08-05 文科潜力股  
select * from scores 
where exam_date = '	2024-06-30' and ((subject = '地理' and score > 90 )or(subject = '历史' and score > 90 )or (subject = '政治' and score > 90 ))
order by score desc ,student_id,subject
2025-08-05 文科潜力股  
select * from scores 
where exam_date = '	2024-06-30' and ((subject = '地理' and score > 90 )or(subject = '历史' and score > 90 )or (subject = '政治' and score > 90 ))
2025-08-05 给英语成绩中上水平的学生拔尖  
select *
from scores
where exam_date = '2024-06-30' and subject = '英语' and score between 100 and 110
2025-08-05 找出三个班级的女生  
select *
 from students
 where class_code in ('C219','C220','C221') and gender = 'f'
 order by student_id
2025-08-04 HAVING-语数英优异的学生  
select student_id,sum(score) as total_score
from scores
where subject in ('语文','数学','英语') and exam_date = '2024-06-30' 
group by student_id
having sum(score) > 330
2025-08-04 HAVING-执教教师超过3人的科目  
SELECT subject
FROM teachers
group by subject
having count(teacher_id) >= 3
2025-08-04 HAVING-执教教师超过3人的科目  
SELECT subject
 FROM teachers
 group by subject
 having count(teacher_id)>3