JJJENNN

分类

/ 注册

全部文章（共38篇）

题解 | 商品销售排名

select product_name, price1 * amount as price from ( select product_name, price as price1, count(trace_id) as amo...

2026-03-02

0 36

题解 | 商品价格排名

select product_id, product_name, type, price from ( select product_id, product_name, type, price, ...

2026-03-02

0 33

题解 | 用户购买次数前三

select uid, count(uid) as cnt from user_client_log where step ="order" group by uid order by uid limit 3

2026-03-02

0 24

题解 | 下单最多的商品

select product_id, count(distinct trace_id) as cnt from user_client_log where step = "order" group by product_id order by product_id...

2026-03-02

0 31

题解 | 统计快递从创建订单到发出间隔时长

select round(avg(timestampdiff(minute,create_time,out_time))/60,3) as time from express_tb join exp_action_tb using (exp_number)

2026-03-02

0 39

题解 | 统计快递运输时长

select exp_type, round(avg(exp_time)/60,1) as time from ( select exp_number, exp_type, timestampdiff(minute,out_ti...

2026-03-02

0 38

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

select exp_number, exp_type, claims_cost from express_tb join exp_cost_tb using (exp_number) where claims_cost is not null order by claims...

2026-02-28

0 43

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

select emp_id, emp_level, tag as exam_tag from( select emp_id, emp_level, tag, exam_id, timestampdiff...

2026-02-28

0 43

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

select round(sum(total)*1.0,3) as sales_total, round(sum(total) / count(distinct user_id) * 1.0 , 3)per_trans from ( select user_i...

2026-02-28

0 43

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

select room_id, room_name, count(distinct user_id) as user_count from user_view_tb join room_info_tb using (room_id) where out_time > &...

2026-02-28

0 31