攸四

分类

/ 注册

全部文章（共40篇）

题解 | SaaS产品高价值用户活跃度分析

with a1 as ( select user_id, user_name, sum(case when event_type='create_task' then 5 when event_type='export_report' then 10 ...

2026-02-06

0 5

题解 | 游戏平台新玩家消费与进阶行为分析

select player_id, username, max(level) as current_level, max(case when level <30 then '新秀玩家' else '高阶玩家' end) as player_category, round(sum(cost),...

2026-02-06

0 6

题解 | SaaS平台企业客户新功能采纳度分析

select team_id, team_name, sum(case when date_format(usage_timestamp,'%Y-%m')='2025-04' and feature_name = 'Advanced_Analytics' then 1 else 0 end) as ...

2026-02-06

0 6

题解 | 在线教育平台活跃学员课程评价分析

with a1 as ( select user_id, date_format(max(review_date),'%Y-%m-%d') as latest_review_date from content_reviews group by user_id) se...

2026-02-06

0 6

题解 | 智能家居设备高能耗异常监控分析

# STEP1 计算各类别平均总耗电量 with a1 as ( select category,sum(usage_kwh)/count(*) as avg_category from smart_devices a left join energy_logs b on a.device_id...

2026-02-06

0 7

题解 | 计算用户的平均次日留存率

with question_practice_detail as ( select distinct device_id,date from question_practice_detail ) select round(count(y.date)/count(x.date),4)...

2026-02-05

0 9

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

#求解答哪里有问题，on_time_rate和avg_minutes_7d一直不对select courier_id,courier_name,city,count(*) as orders_7d,sum(case when timestampdiff(minute,shipped_ts,deliv...

2026-01-29

0 14

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

with a1 as( select class_id, course_id, teacher_id, count(distinct student_id) as learners_active_m, COUNT(DISTINCT CASE WHEN...

2026-01-29

0 13

题解 | 最畅销的SKU

with a1 as ( select c.store_id,c.sku_id,sum(qty) as last7d_qty from sales_daily_ c join store_stock_ b on b.store_id = c.store_id an...

2026-01-29

0 11

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

with a1 as ( select visit_id, dept, patient_id, datediff(visit_date,(lag(visit_date) over(partition by dept,patient_id order by v...

2026-01-28

0 14