冰淇淋12322

分类

/ 注册

全部文章（共17篇）

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

with user_base as ( -- 基础用户：Pro用户 + Q1有登录 select distinct u.user_id, u.user_name from users u inner join user_events ...

2026-02-02

0 12

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

# 1、查询完成了 “数据科学进阶” (course_id= 'DS-102') 课程的所有学员2025-03 with t1 as ( select distinct user_id from course_completions where completion_date between '20...

2026-02-02

0 12

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

# 1、计算每台设备总用电量 with t1 as ( select e.device_id, device_name, location, category, sum(usage_kwh) as sum_usage from energy_l...

2026-02-01

0 14

题解 | 更新用户积分信息？

with t as( select user_id, sum(order_price) as total_p from order_tb where order_price > 100 group by user_id ) select u.user...

2025-10-27

0 41

题解 | 每个商品的销售总额

select product_name, total_sales, row_number() over(partition by category order by total_sales desc, product_id asc) as category_rank from ( select o....

2025-10-27

0 35

题解 | 推荐内容准确的用户平均评分

select round(avg(score),3) as avg_score from ( select rec_info_l, rec_user from recommend_tb group by 1,2 ) r inner join user_action_tb u...

2025-10-27

0 43

题解 | 每天的日活数及新用户占比

select dt, count(distinct uid) as dau, round(sum(case when first_dt = dt then 1 else 0 end)/count(distinct uid), 2) as uv_new_ratio from( select uid, ...

2025-10-25

0 38