排名

用户解题统计

过去一年提交了

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

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-02-13 销售金额前10的商品信息（2）  
select
*
from(
select
order_date,
goods_id,
total_gmv,
dense_rank()over(partition by order_date order by total_gmv)as ranking
from(
select
date(order_time)as order_date,
goods_id,
sum(order_gmv)as total_gmv
from order_info
group by order_date,goods_id)as a)as b
where ranking <=10
2026-02-13 销售金额前10的商品信息（2）  
select
*
from(
select
order_date,
goods_id,
total_gmv,
row_number()over(partition by order_date order by total_gmv)as ranking
from(
select
date(order_time)as order_date,
goods_id,
sum(order_gmv)as total_gmv
from order_info
group by order_date,goods_id)as a )as b
2026-02-13 至少两门科目大于等于110分的学生  
select
*
from subject_score
where 
chinese>110 and math>110 orchinese>110 and english>110 or math>110 and english>110
2026-02-12 周杰伦的最受欢迎的专辑  
select 
listen.user_id,
listen.song_id,
s .song_name,
listen.num
from(
select
user_id,
song_id,
count(id)as num
from listen_rcd
where user_id='u003'and if_finished=1
group by user_id,song_id)as listen 
 left join 
 (select
song_id,
song_name 
from song_info)as s
 on listen.song_id = s.song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
song_id ,
count(id)as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
song_id ,
count(song_id)as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
user_id,
song_id ,
count(id)as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by user_id,song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
user_id,
song_id ,
count(id )as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by user_id,song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
user_id,
song_id ,
count(song_id )as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by user_id,song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
user_id,
song_id ,
count(song_id )as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by song_id
2026-02-12 周杰伦的最受欢迎的专辑  
select 
user_id,
song_id ,
count(song_id )as mun
from listen_rcd
where user_id='u003' 
and if_finished= 1
group by 2
2026-02-12 周杰伦的最受欢迎的专辑  
select distinct
user_id,
song_id 
from listen_rcd
where user_id='u003' 
and if_finished=1