排名

用户解题统计

过去一年提交了

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

错题集 数据思维刷题中答错的题目

模块 知识点 题目 你的答案 正确答案 操作
暂无错题，继续保持！

收藏

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

评论笔记

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

提交记录

提交日期 题目名称 提交代码
2026-05-25 京东（三）热门页面分析  
select click_page_id,
			count(click_page_id) as visit_cnt
from jx_click_rcd
group by click_page_id
order by visit_cnt desc
limit 10
2026-05-25 建设银行（一）商户交易分析  
select mch_nm,
 			count(mch_nm) as trx_cnt,
sum(trx_amt) as total_amt
from ccb_trx_rcd
group by mch_nm
order by sum(trx_amt) desc
limit 10
2026-05-25 销售金额前10的商品信息  
with t1 as(
select goods_id,
 		 date(order_time) as order_date,
 		 sum(order_gmv) as daily_gmv
from order_info
group by goods_id,date(order_time)
 ),
 	t2 as(
select goods_id ,
		sum(daily_gmv)over(partition by goods_id) as total_gmv
from t1
where order_date = '2024-09-10'
)
select * from t2 
order by total_gmv desc
limit 10
2026-05-25 销售金额前10的商品信息  
with t1 as(
select goods_id,
 		 date(order_time) as order_date,
 		 sum(order_gmv) as daily_gmv
from order_info
group by goods_id,date(order_time)
 ),
 	t2 as(
select goods_id ,
		sum(daily_gmv)over(partition by goods_id) as total_gmv
from t1
where order_date = '2024-09-10'
)
select * from t2 limit 10
2026-05-25 销售金额前10的商品信息  
with t1 as(
select goods_id,
 		 date(order_time) as order_date,
 		 sum(order_gmv) as daily_gmv
from order_info
group by goods_id,date(order_time)
 ),
 	t2 as(
select goods_id ,
		order_date,
		sum(daily_gmv)over(partition by goods_id) as total_gmv
from t1
where order_date = '2024-09-10'
)
select * from t2 limit 10
2026-05-25 销售金额前10的商品信息  
with t1 as(
select goods_id,
 		 date(order_time) as order_date,
 		 sum(order_gmv) as daily_gmv
from order_info
group by goods_id,date(order_time)
 ),
 	t2 as(
select goods_id ,
		order_date,
		sum(daily_gmv)over(partition by goods_id) as total_gmv
from t1
where order_date = '2024-09-10'
)
select * from t2