桑榆未晚jiang

分类

/ 注册

全部文章（共12篇）

题解 | 近7天骑手履约时效看板

with a as (select p1.courier_id, count(distinct parcel_id) orders_7d1, count(if(timestampdiff(second,shipped_ts,delivered_ts)/60<=promised_...

2025-12-16

0 6

题解 | 目标月份的品类销售简报

with a as ( select category, ifnull(count(distinct oi.order_id),0) orders_cnt, ifnull(count(distinct buyer_id),0) buyers_cnt, ifnull(sum(q...

2025-12-16

0 7

题解 | 统计每个班级的关键指标

with a as ( select class_id,count(distinct student_id) learners_active_m1,count(distinct (if(finished_flag=1,student_id,null))) finishers_m1,sum(watch...

2025-12-16

0 6

题解 | 最畅销的SKU

with a as (select store_id,sku_id,stock_qty,snapshot_date,max(snapshot_date) over(partition by store_id,sku_id ) max_sdate from store_stock_ ), b as(...

2025-12-15

0 9

题解 | 医院门诊复诊率与抗生素用药占比统计

with a as ( select *,lag(visit_date) over(partition by dept,patient_id order by visit_date asc) l_date from visits), b as( select dept,ifn...

2025-12-15

0 7

题解 | 下单复盘

with a as(select o.customer_id, count(distinct o.order_id) co, round(sum(qty*price),2) rs, round(sum(qty*price)/count(distinct o.order_id)...

2025-12-09

0 11

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

#处理基础表 with e as ( select event_id,user_id,campaign_id,event_type,channel,event_time,date_format(event_time,'%Y%m') d_f,year(event_time) d_y ...

2025-12-01

0 10

题解 | 贷款情况

select b.city,round(sum(loan_amount),2) total_loan_amount,round(sum(loan_amount)/count(distinct b.customer_id ),2) average_loan_amount,round(count(dis...

2025-11-27

0 12

题解 | 统计借阅量

with a as ( select record_id,book_id,branch_id,date_format(borrow_date,'%Y%m') d_f,year(borrow_date) d_y from BorrowRecords) select Books...

2025-11-27

0 7

题解 | 统计骑手信息

with o as ( select order_id,courier_id,zone_id,date_format(delivered_time,'%Y%m') d_f ,timestampdiff(minute,order_time,delivered_time) t_d fro...

2025-11-27

0 9