lizhenzhen

分类

/ 注册

全部文章（共65篇）

题解 | 统计快递运输时长

select exp_type, round(avg(timestampdiff(minute,out_time,in_time)/60),1) as time from exp_action_tb e1 join express_tb e2 on e1.exp_number=e2...

2025-12-04

2 23

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

select round(sum(goods_price*sales_num),3) as sales_total, round(sum(goods_price*sales_num)/count(distinct user_id),3) as per_trans from sale...

2025-12-04

1 19

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

select e1.exp_number, exp_type, claims_cost from exp_cost_tb e1 join express_tb e2 on e1.exp_number=e2.exp_number where claims_cost is not...

2025-12-04

1 20

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

-- 求平均用时和平均分数 with er as (select *, avg(timestampdiff(second,start_time,submit_time)) over(partition by exam_id) as avg_time, avg(score) ...

2025-12-04

1 19

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

select round(sum(goods_price*sales_num),3) as sales_total, round(sum(goods_price*sales_num)/count(distinct user_id),3) as per_trans from sale...

2025-12-04

1 20