最爱青草蛋糕

分类

/ 注册

全部文章（共105篇）

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

with t as ( select courier_id,courier_name,city, count(parcel_id) as orders_7d, count(if(timestampdiff(second,shipped_ts,delivered_ts)/60 <= promis...

2025-12-03

0 18

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

with t as ( select class_id,course_id,teacher_id, count(distinct student_id) as learners_enrolled, sum(if(date_format(log_ts,'%Y-%m-%d') between '2024...

2025-12-01

0 20

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

with t as ( select class_id,course_id,teacher_id, count(distinct student_id) as learners_enrolled, sum(if(date_format(log_ts,'%Y-%m-%d') between '2024...

2025-12-01

0 19

题解 | 最畅销的SKU

with t as ( select store_id,store_name,city,sku_id, ifnull(sum(qty),0) as last7d_qty, round(ifnull(sum(qty),0)/7,2) as avg_daily_qty, max(stock_qty) ...

2025-11-28

0 24

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

with t as ( select dept,count(distinct visit_id) as feb_2024_visits, count(distinct patient_id) as feb_2024_unique_patients, ifnull(round(sum(if(is_an...

2025-11-27

0 21

题解 | 下单复盘

select customer_id,customer_name,count(distinct order_id) as feb_2024_order_count, ifnull(sum(price*qty),0) as feb_2024_total_amount, round(ifnull(su...

2025-11-26

0 20

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

with t as ( select campaign_id,campaign_name, sum(if(date_format(event_time,'%Y-%m') = '2023-02' and event_type = 'signup',1,0)) as conv_2023_02, sum(...

2025-11-25

0 24

题解 | 统计骑手信息

#前n-1个字段 with t as (select zone_id,zone_name, sum(if(date_format(delivered_time,'%Y-%m') = '2023-02',1,0)) as peak_2023_02_delivered, sum(if(date_form...

2025-11-21

0 22

题解 | 找到特殊的电话号码

select distinct 电话号码 from 电话费用表 where 月份 between '201701' and '201710' and( substr(电话号码,-4) regexp "([0-9])\\1([0-9])\\2" or substr(电话号码,-4)...

2025-11-21

0 29

题解 | 计算薪资涨幅

select 雇员编号,max(薪水)-min(薪水) as 薪水涨幅 from 薪水表 group by 雇员编号 having max(结束日期) = '2004-01-01'

2025-11-20

0 26