Sunshine晶晶

分类

/ 注册

全部文章（共86篇）

题解 | 每类视频近一个月的转发量/率

SELECT tag,COUNT(CASE WHEN if_retweet=1 THEN tb.video_id END) AS retweet_cnt, ROUND(COUNT(CASE WHEN if_retweet=1 THEN tb.video_id END)/COUNT(tb....

2026-03-11

0 49

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

WITH RECURSIVE t AS ( SELECT m2.member_id AS referee_id, m2.member_name AS referee_name, 1 AS referral_level, ROUN...

2026-03-09

2 48

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

WITH RECURSIVE t AS ( SELECT c2.cat_id AS descendant_id, c2.cat_name AS descendant_name, 1 AS generation, ROUND(h...

2026-03-09

0 39

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

WITH RECURSIVE t AS ( SELECT s2.service_id, s2.service_name, 1 AS dependency_depth, CONCAT('Payment_Gateway','-&g...

2026-03-09

0 43

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

SELECT p.player_id, username, MAX(level) AS current_level, CASE WHEN MAX(level)>=30 THEN '高阶玩家' ELSE '新秀玩家' END AS player_cate...

2026-03-06

0 43

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

WITH t AS ( SELECT t1.team_id,team_name, COUNT(usage_id) AS april_usage_count, CASE WHEN COUNT(usage_id)>50 THEN '深度采纳团队'...

2026-03-06

0 49

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

WITH t1 AS ( SELECT c.user_id, ROUND(AVG(rating),2) AS average_rating, CASE WHEN AVG(rating)>=4 THEN '优质反馈学员' ELSE '普通反馈学员' END AS...

2026-03-05

0 41

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

WITH t1 AS ( SELECT s.device_id, device_name, location, category, ROUND(SUM(usage_kwh),2) AS total_usa...

2026-03-05

0 37

题解 | 最畅销的SKU

WITH t AS ( SELECT s.store_id, store_name, city, s1.sku_id, COALESCE(SUM(qty),0) AS last7d_qty, ...

2026-03-03

0 35

题解 | 下单复盘

SELECT c.customer_id, customer_name, COUNT(DISTINCT o.order_id) AS feb_2024_order_count, ROUND(IFNULL(SUM(qty*price),0),2) AS feb...

2026-02-28

0 31