Tendernessnick

分类

/ 注册

全部文章（共114篇）

题解 | 商品销售排名

with t1 as( select product_name, sum(price) as total from user_client_log left join product_info using(product_id) ...

2025-11-19

0 17

题解 | 商品价格排名

with t1 as( select product_id, product_name, type, price, dense_rank()over(partition by type order by pric...

2025-11-19

0 16

题解 | 用户购买次数前三

with t1 as( select uid, count(uid) from user_client_log where step='order' group by uid or...

2025-11-19

0 14

题解 | 下单最多的商品

with t1 as( select product_id, count(product_id) as cnt from user_client_log where step='order' group ...

2025-11-19

0 18

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

with t1 as( select avg(timestampdiff(minute,create_time,out_time)/60) as time from exp_action_tb left join express_tb using(ex...

2025-11-19

0 16

题解 | 统计快递运输时长

with t1 as( select exp_type, avg(timestampdiff(second,out_time,in_time)/3600) as avg_time from exp_action_tb left join...

2025-11-19

0 18

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

with t1 as( select exam_id, avg(timestampdiff(second,start_time,submit_time)/60) as avg_time, avg(score) as avg_score ...

2025-11-19

0 13

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

with t1 as( select sum(sales_num*goods_price), sum(sales_num*goods_price)/count(distinct user_id) from sales_tb left j...

2025-11-19

0 19

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

with t1 as( select room_id, room_name, count(distinct user_id) as user_count from user_view_tb left join room_...

2025-11-19

0 17

题解 | 被重复观看次数最多的3个视频

with t1 as( select uid, cid, release_date, count(uid) as watch_times from play_record_tb left join cou...

2025-11-19

0 15