Sunshine晶晶

分类

/ 注册

全部文章（共86篇）

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

WITH order_customer_agg AS ( SELECT shop_id, customer_name, product_name, SUM(quantity) AS sum_qty, SU...

2026-04-20

0 8

题解 | SaaS产品租户核心功能模块用量及占比分析

WITH t1 AS ( SELECT u.tenant_id, module_name, SUM(call_count) AS total_calls, round(SUM(call_count)/avg(total_cn...

2026-04-13

0 21

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

WITH t1 AS ( SELECT route_id, rider_name, completion_min, ride_date, ride_id, avg_spee...

2026-04-13

0 20

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

WITH t AS ( SELECT e.team_id, match_id, team_name, region, match_date, opponent, ...

2026-04-09

2 22

题解 | 统计活跃间隔对用户分级结果

WITH t1 AS ( SELECT * FROM (SELECT uid,MIN(DATE(in_time)) AS first_in_time, MAX(DATE(out_time)) AS last_out_time FROM tb_user_l...

2026-03-31

0 37

题解 | 超充站故障派单链路统计

WITH RECURSIVE t AS ( SELECT task_id AS root_task_id, f.station_id AS root_station_id, task_id AS current_task_id, ...

2026-03-20

0 42

题解 | 找出补位班次

WITH t1 AS ( SELECT shift_id, rider_id, MIN(invited_at) AS first_invite_time FROM shift_invite_responses GROUP BY sh...

2026-03-19

0 45

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

WITH RECURSIVE t1 AS( SELECT share_id AS root_share_id, sharer_account_id AS root_account_id, share_id AS curren...

2026-03-18

0 41

题解 | 完成员工考核试卷突出的非领导员工

WITH t AS ( SELECT exam_id, AVG(TIMESTAMPDIFF(MINUTE,start_time,submit_time)) AS avg_time, avg(score) AS avg_score FROM exam_record...

2026-03-18

0 46

题解 | 国庆期间每类视频点赞量和转发量

WITH t1 AS ( SELECT tag, DATE_FORMAT(start_time,'%Y-%m-%d') AS dt, SUM(if_like) AS like_cnt, SUM(if_retweet) AS r...

2026-03-16

0 38