bbbbbbg

分类

/ 注册

全部文章（共20篇）

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

select a.shop_name, a.city, a.product_name as top_product, a.gmv as product_revenue, b.customer_name as top_customer, b.qty as...

2026-04-20

1 10

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

with base as ( select t.*, a.module_name, a.total_calls from tenants t join lateral ( select ...

2026-04-20

0 7

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

with recursive cte as ( select f.task_id as root_task_id, c.station_name as station_name, f.task_id, 0 as max_dep...

2026-04-20

0 10

题解 | 找出补位班次

with min_dt as( select s.shift_id, s.rider_id, min(invited_at) as min_date from relief_shifts r left join ...

2026-04-20

0 8

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

with recursive t1 as ( select c.share_id as root_share_id, p.account_name as root_account_name, c.share_id as id, ...

2026-04-20

0 10

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

select cr.route_name, cr.distance_km, t.rider_name, t.ride_date, t.completion_min, t.avg_speed_kmh from cycling_routes cr ...

2026-04-13

0 22

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

with recursive cte as ( select r.referee_id, m1.member_name, 1 as depth, r.base_reward_points * pow(0.5,0) as actu...

2026-04-13

0 22

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

with recursive cte as ( select r.referee_id, m1.member_name, 1 as depth, r.base_reward_points * pow(0.5,0) as actu...

2026-04-13

0 25

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

select t1.emp_id, t1.emp_level, t.tag from (select e.exam_id, e.tag, avg(er.score) as avg_score, avg(timestampdiff(minute,...

2026-04-04

0 24

题解 | 统计用户从访问到下单的转化率

select b.o_date as date, concat(round(b.cnt*100/a.cnt,1),'%') as cr from ( select date(visit_time) as vi_date, count(distinct user_id)...

2026-04-01

0 23