排名

用户解题统计

过去一年提交了

勋章 ①金银铜:在竞赛中获得第一二三名;②好习惯:自然月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