排名

用户解题统计

过去一年提交了

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

收藏

收藏日期 题目名称 解决状态
2026-03-02 每年在深交所上市的银行有多少家  未解决
2026-03-02 不分类别的最火直播间  已解决

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-03-02 按照车类统计行程次数  
SELECT car_cls, COUNT(*) AS cnt
FROM didi_sht_rcd
GROUP BY car_cls
ORDER BY cnt DESC
2026-03-02 不分类别的最火直播间  
SELECT t1.live_id, t2.live_nm, COUNT(*) AS enter_cnt
FROM ks_live_t1 t1
JOIN ks_live_t2 t2
	USING (live_id)
WHERE enter_time REGEXP '2021-09-12 23'
GROUP BY t1.live_id, t2.live_nm
ORDER BY enter_cnt DESC
LIMIT 5
2026-03-02 分组与聚合函数（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 REGEXP '2024'
GROUP BY mch_nm
ORDER BY sum_trx_amt DESC
2026-03-01 输出特定日期上市的银行  
SELECT *
FROM stock_info
WHERE list_date BETWEEN '2006-06-01' AND '2006-09-01' AND industry = '银行'
2026-03-01 A和K之间的手牌（3）  
SELECT *
FROM hand_permutations
WHERE (card1 BETWEEN 'A' AND 'K') AND (card2 BETWEEN 'A' AND 'K')
2026-03-01 A和K之间的手牌（2）  
SELECT *
FROM hand_permutations
WHERE card1 BETWEEN 'A' AND 'K' OR card2 BETWEEN 'A' AND 'K'
2026-03-01 A和K之间的手牌（1）  
select *
FROM hand_permutations
WHERE card1 BETWEEN 'A' AND 'K'
2026-03-01 交易金额在5000至10000（含边界）的所有交易  
SELECT *
FROM cmb_usr_trx_rcd
WHERE trx_amt BETWEEN 5000 AND 10000
ORDER BY trx_amt DESC
LIMIT 5
2026-03-01 交易金额大于10000元的所有交易  
SELECT *
FROM cmb_usr_trx_rcd
WHERE trx_amt > 100000
ORDER BY trx_amt DESC
2026-02-28 大于J小于K的手牌  
SELECT *
FROM hand_permutations
WHERE card1 > 'J' AND card1 < 'K'
	AND card2 > 'J' AND card2 < 'K'
ORDER BY id ASC
2026-02-28 语文数学英语至少1门超过100分的同学  
SELECT *
FROM subject_score
WHERE chinese > 100 OR math > 100 OR english >100
ORDER BY chinese ASC
2026-02-28 性别已知的听歌用户  
SELECT *
FROM qqmusic_user_info
WHERE gender IN ('f','m') 
	AND (birth_date BETWEEN '1980-01-01' AND '1980-12-31')
ORDER BY birth_date ASC
2026-02-28 2000年以前出生的男歌手  
SELECT *
FROM singer_info
WHERE birth_date < '2000-01-01' AND gender = 'm'
2026-02-28 21世纪上市的银行  
SELECT *
FROM stock_info
WHERE list_date >= '2000-01-01' AND industry = '银行'
ORDER BY list_date ASC
2026-02-26 总分超过300分的学生  
SELECT student_id
FROM subject_score
WHERE (chinese + math + english) >= 300
2026-02-26 国庆假期后第一天涨幅高于1%的股票  
SELECT ts_code, open_price, close_price
FROM daily_stock_prices
WHERE trade_date = '2023-10-09' AND pct_change > 1
2026-02-26 国庆假期后第一天涨幅高于1%的股票  
SELECT *
FROM daily_stock_prices
WHERE trade_date = '2023-10-09' AND pct_change > 1
2026-02-26 输出地区为北京的所有银行  
SELECT *
FROM stock_info
WHERE area = '北京' AND industry = '银行'
ORDER BY list_date ASC
2026-02-26 1989年12月13日出生的女歌手  
SELECT *
FROM singer_info
WHERE birth_date = '1989-12-13' AND gender = 'f'
2026-02-26 找出所有港台乐队  
SELECT *
FROM singer_info
WHERE type2 = '港台' AND type3 = '乐队'
ORDER BY singer_id ASC