攸四

分类

/ 注册

全部文章（共40篇）

题解 | 内容社区用户活跃度、转化与广告归因分析

with a1 as ( select campaign_id, event_type, event_time, lead(event_time) over(order by event_time) as next_event_time, lead(...

2026-01-28

0 13

题解 | 统计骑手信息

with a1 as ( select zone_id, courier_id, courier_name, count(*) as courier_count, rank() over(partition by zone_id order by c...

2026-01-28

0 16

题解 | 统计借阅量

select book_id, book_title, sum(case when borrow_date between '2023-02-01' and '2023-02-28' then 1 else 0 end ) as feb_2023_borrows, sum(case when bo...

2026-01-27

0 11

题解 | 贷款情况

with a1 as ( select city , loan_type_id, loan_type_name, rank() over(partition by city order by count(*) desc ,loan_type_id) as rk from loan_applicat...

2026-01-27

0 15

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

select weather_type, round(sum(delivery_time*delivery)/sum(delivery),2) as average_delivery_time, sum(delivery) as delivery_count from ( select weathe...

2026-01-27

0 19

题解 | 了解 2023 年全年所有商品的盈利情况

select product_id, sum(total_profit) as total_profit, round(avg(profit_margin),2) as profit_margin from ( select product_id, quantity*(unit_price-pu...

2026-01-27

0 15

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

select a.courier_id,courier_name, round(base_salary+sum(delivery_fee)-avg(courier_expense_amount),2) as total_income from couriers_info a left join de...

2026-01-26

0 15

题解 | 分析每个商品在不同时间段的销售情况

select a.product_id,product_name, sum(case when total_amount is not null then total_amount else 0 end) as q2_2024_sales_total, rank() over(partition b...

2026-01-26

0 14

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

select merchant_id,merchant_name, round(sum(sale_amount)/2,2) as total_sales_amount, round(sum(refund_amount)/4,2) as total_refund_amount, round(avg(s...

2026-01-22

0 18

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

with a1 as ( select exam_id,avg(timestampdiff(second,start_time,submit_time)/60) as avg_exam_time,avg(score) as avg_exam_score from exam_recor...

2026-01-14

0 25