排名
用户解题统计
过去一年提交了
勋章 ①金银铜:在竞赛中获得第一二三名;②好习惯:自然月10天提交;③里程碑:解决1/2/5/10/20/50/100/200题;④每周打卡挑战:完成每周5题,每年1月1日清零。
收藏
收藏日期 | 题目名称 | 解决状态 |
---|---|---|
没有收藏的题目。 |
评论笔记
评论日期 | 题目名称 | 评论内容 | 站长评论 |
---|---|---|---|
没有评论过的题目。 |
提交记录
提交日期 | 题目名称 | 提交代码 |
---|---|---|
2025-01-14 | A和K之间的手牌(3)  |
select * from hand_permutations where card1 between 'a' and 'k' and card2 between 'a' and 'k' |
2025-01-14 | A和K之间的手牌(1)  |
select * from hand_permutations where card1 between 'a' and 'k' |
2025-01-14 | A和K之间的手牌(1)  |
select * from hand_permutations where card1 between 'K' and 'A' order by id |
2025-01-14 | A和K之间的手牌(1)  |
select * from hand_permutations where card1 between 'j' and 'k' order by id |
2025-01-14 | A和K之间的手牌(1)  |
select * from hand_permutations where card1 between 'j' and 'k' |
2025-01-14 | 交易金额大于10000元的所有交易  |
select * from cmb_usr_trx_rcd where trx_amt>100000 order by trx_amt desc |
2025-01-14 | 大于J小于K的手牌  |
select * from hand_permutations where (card1>'j' and card1<'k') and (card2>'j' and card2<'k') |
2025-01-14 | 语文数学英语至少1门超过100分的同学  |
select * from subject_score where chinese>100 or math>100 or english>100 order by chinese |
2025-01-14 | 性别已知的听歌用户  |
select * from qqmusic_user_info where gender in ('f','m') and year(birth_date)=1980 order by birth_date |
2025-01-14 | 2000年以前出生的男歌手  |
select * from singer_info where year(birth_date)<'2000' and gender='m' |
2025-01-14 | 21世纪上市的银行  |
select * from stock_info where year(list_date)>=2000 and industry='银行' order by list_date |
2025-01-14 | 输出地区为北京的所有银行  |
select * from stock_info where area='北京' and industry='银行' order by list_date |
2025-01-14 | 输出地区为北京的所有银行  |
select * from stock_info where area='北京' order by list_date |
2025-01-14 | 1989年12月13日出生的女歌手  |
select * from singer_info where birth_date='1989-12-13'and gender='f' |
2025-01-14 | 找出所有港台歌手  |
select * from singer_info where type2='港台' order by singer_id |
2025-01-14 | 找出所有港台歌手  |
select * from singer_info where type2='港台' and type3='个人' order by singer_id |
2025-01-14 | 找出所有港台乐队  |
select * from singer_info where type2='港台' and type3='乐队' order by singer_id |
2025-01-14 | 查询播放量为0的歌手及其专辑  |
SELECT s.singer_id, s.singer_name, a.album_id, a.album_name, COUNT(l.id) AS play_count FROM singer_info s JOIN album_info a ON s.singer_id = a.singer_id LEFT JOIN song_info sg ON a.album_id = sg.album_id LEFT JOIN listen_rcd l ON sg.song_id = l.song_id GROUP BY s.singer_id, s.singer_name, a.album_id, a.album_name HAVING play_count = 0; |
2025-01-13 | 用户听歌习惯的时间分布  |
select user_id,dayname(date(start_time)),count(user_id) from listen_rcd group by user_id,dayname(date(start_time)) order by user_id |
2025-01-13 | 特定歌曲的播放记录  |
select * from listen_rcd where date(start_time) between '2023-12-10' and '2023-12-31' and song_id=13 order by start_time |