爱吃土豆儿333

分类

/ 注册

全部文章（共4篇）

题解 | 宠物猫繁育族谱追溯与遗传病风险评估

with recursive t as ( select c2.cat_id as descendant_id, c2.cat_name as descendant_name, 1 as generation, round(br.health_score ...

2026-03-03

0 10

题解 | 最长连续登录天数

WITH t1 AS ( -- 1) 先筛选 2023-01-01 ~ 2023-01-31 的活跃数据，并去重 -- （避免同一用户同一天多条记录影响连续天数统计） SELECT DISTINCT fdate, user_id ...

2026-02-24

0 16

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

WITH use_fre AS ( SELECT t.team_id, t.team_name, COUNT(f.usage_timestamp) A...

2026-02-20

0 16

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

with date_table as ( select t2.user_id, date_format(Max(t2.review_date), "%Y-%m-%d") AS latest_review_da...

2026-02-08

0 20