理智的海豚要双休

分类

/ 注册

全部文章（共3篇）

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

with pro_user_id as ( select distinct user_id, user_name from users where registration_date between '2025-01-01' and '2025-06-...

2026-02-03

0 8

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

with lastest_rate_date as ( select user_id, max(date(review_date)) as latest_review_date from content_reviews group by user_id...

2026-02-03

0 8

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

with total_avg_kwh as ( select sd.category, round(avg(el.usage_kwh),2) as avg_kwh from energy_logs el left join smart_devices sd on el.device_id=sd.de...

2026-02-03

0 9