我的名字在哪里

分类

/ 注册

全部文章（共44篇）

题解 | 播客精彩片段裂变传播链统计

WITH RECURSIVE tmp AS( -- 找到根节点 SELECT cs.share_id root_share_id, account_name root_account_name, cs.share_id cur_share_id, cs...

2026-04-15

0 16

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

WITH a AS( SELECT cs.shop_id, shop_name, city, product_name, product_revenue FROM coffee_shops cs CROSS JOIN LATERAL( SELECT product_name, SUM(quant...

2026-04-15

0 18

题解 | 骑行运动社区路线个人最佳排名

SELECT cr.route_name, cr.distance_km, t.rider_name, t.ride_date, t.completion_min, t.avg_speed_kmh FROM cycling_routes cr CRO...

2026-04-15

0 13

题解 | 电竞赛事战队近期战绩查询

/* WITH a AS( SELECT et.team_id, team_name, region, game_type, match_date, opponent, kills, deaths, match_id, kills/deaths, CASE WHEN is_win ...

2026-04-15

0 15

题解 | 全民健身季推荐网络与积分衰减计算

WITH recursive tmp AS( -- 查第一次推荐的 SELECT rr.referee_id, m.member_name referee_name, 1 referral_level, rr.base_reward_points FROM referra...

2026-04-15

0 15

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

WITH recursive temp AS( SELECT br.child_cat_id AS descendant_id, c.cat_name AS descendant_name, 1 AS generation, br.healt...

2026-04-15

0 16

题解 | 微服务架构下的深层依赖链路漏洞影响面分析

WITH recursive temp AS( SELECT service_id, service_name, 0 dependency_depth, service_name dependency_path FROM services WHERE service_name...

2026-04-15

1 13

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

WITH a AS( SELECT ue.user_id, user_name, CASE WHEN event_type='create_task' THEN 5 WHEN event_type='export_report' THEN 10 WHE...

2026-04-15

0 18

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

WITH a AS( SELECT team_id, team_name, plan_level FROM teams WHERE plan_level = 'Enterprise' ), b AS( SELECT team_id, feature_name, usa...

2026-04-15

0 18

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

WITH completed_users AS ( -- 2025年3月完成课程 DS-102 的学员（去重） SELECT DISTINCT user_id FROM course_completions WHERE course_id = 'DS-102' ...

2026-04-15

0 14