cantin

分类

题解(3)

/ 注册

全部文章（共30篇）

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

with temp0 as ( select dept, count(*) as feb_2024_visits, count(distinct patient_id) as feb_2024_uniqu...

2026-04-18

0 9

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

with temp0 as ( select campaign_id,count(*) as conv_2023_02 from Events where date_format(event_time,"%Y-%m") = "2023-02&qu...

2026-04-18

0 9

题解 | 精品咖啡连锁门店王牌产品及其最忠实顾客分析

with temp0 as ( select shop_id, product_name, sum(quantity*unit_price) as total_price, sum(quantity) as total_cou...

2026-04-08

0 23

题解 | SaaS产品租户核心功能模块用量及占比分析

with temp0 as ( select tenant_id,sum(call_count) as total_calls from usage_logs group by tenant_id ), temp1 as ( select tenant_id,modu...

2026-04-07

0 35

题解 | 最差是第几名(二)

-- 6: 3 and 4 -- 7: 4 and 4 -- 12: 6 and 7 with temp0 as ( select sum(number) as total_number from class_grade ), temp1 as ( select floor...

2026-02-21

0 50

题解 | 牛客的课程订单分析(五)

with temp0 as ( select user_id,count(*) as cnt from order_info oi where date >= "2025-10-15" and product_name in ("C++&q...

2026-02-20

0 49

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

with temp0 as ( select distinct u.user_id from users u inner join user_events ue on u.user_id = ue.user_id where plan_type = "Pro...

2026-02-07

0 60

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

with temp0 as ( select category,round(sum(usage_kwh)/count(*),2) as avg_usage_kwh from smart_devices sd inner join energy_logs el on sd.d...

2026-02-07

0 56

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

with temp0 as ( select distinct p.player_id from players p inner join transactions t on p.player_id = t.player_id where date_format(cr...

2026-02-03

0 59

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

with temp0 as ( select team_id,min(date_format(usage_timestamp,"%Y-%m-%d")) as first_ever_usage_date from feature_usage group by...

2026-02-03

0 65