11ele

分类

/ 注册

全部文章（共4篇）

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

with temp1 as ( select shop_id,shop_name,city,product_name,sum_sale as product_revenue,rank() over(partition by shop_name order by sum_sale desc,n...

2026-04-19

0 10

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

with temp as ( select author_id,date_sub(answer_date,interval rk day) as time,count(*) as days_cnt from ( select distinct author_id,answer_da...

2026-04-10

0 22

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

with recursive temp as ( select task_id as root_task_id, f.station_id as root_station_id, task_id as current_task_id, 0 as depth,...

2026-03-31

0 25

题解 | 找出补位班次

with t as ( select shift_id,store_id,shift_date,shift_period,required_rider_count,published_at from relief_shifts where shift_date betwe...

2026-03-30

0 24