最爱青草蛋糕

分类

/ 注册

全部文章（共74篇）

题解 | 商品销售总额分布

select case when pay_method = '' then 'error' else pay_method end as pay_method, count(1) as num from ( select p.product_id,product_name,pay_method ...

2025-08-15

0 26

题解 | 商品销售排名

select product_name,sale from ( select p.product_id,price*num as sale,product_name, rank()over(order by price*num desc) as rank_num from product_info...

2025-08-15

0 29

题解 | 商品价格排名

select product_id,product_name,type,price from (select product_id,product_name,type,price, rank()over(partition by type order by price desc) as rank_...

2025-08-15

0 30

题解 | 用户购买次数前三

select uid,cnt from ( select uid,count(1) as cnt, rank()over(order by count(1) desc) as count_num from ( select trace_id,uid from user_client_log gro...

2025-08-14

1 39

题解 | 下单最多的商品

select product_id,count(1) as cnt from ( select product_id,trace_id from user_client_log group by product_id,trace_id) as t1 group by product_id order...

2025-08-14

0 24

题解 | 统计快递运输时长

select exp_type,round(sum(unit_time)/count(1)/3600,1) as time from ( select t1.exp_number, exp_type,unit_time from express_tb join ( select exp_numbe...

2025-08-13

0 23

题解 | 查询产生理赔费用的快递信息

select t1.exp_number,exp_type,claims_cost from express_tb join ( select exp_number,claims_cost from exp_cost_tb ) as t1 on express_tb.exp_number = t1...

2025-08-13

0 31

题解 | 完成员工考核试卷突出的非领导员工

select emp_id,emp_level,tag as exam_tag from (select t4.exam_id as exam_id,avg_time,avg_record,emp_id,tag,emp_level,time_count,score from (select exam...

2025-08-13

0 29

题解 | 淘宝店铺的实际销售额与客单价

select round(sum(ps),3) as sales_total,round(sum(ps)/sum(count_1),3) as per_trans from ( select user_id,sum(goods_price*sales_num) as ps, 1 as count_...

2025-08-12

0 28

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

select r.room_id, room_name, user_count from room_info_tb as r join (select room_id,count(1) as user_count from ( select user_id,room_id from ( selec...

2025-08-12

0 25