cantin

分类

题解(3)

/ 注册

全部文章（共26篇）

题解 | 最畅销的SKU

with temp0 as ( select max(sale_date) as latest_date from sales_daily_ ), temp1 as ( selec...

2025-12-15

0 53

题解 | 统计每个班级的关键指标

with temp0 as ( select cc.class_id, course_id, teacher_id, count(ce.student_id) as learner...

2025-12-02

0 54

题解 | 每个月Top3的周杰伦歌曲

select month, ranking, song_name, play_pv from ( select month, row_number() over ( ...

2025-11-25

0 40

题解 | 统计借阅量

with temp0 as ( select br.book_id, count(*) as feb_2023_borrows from BorrowRecords br ...

2025-11-19

0 54

题解 | 分析客户逾期情况

select pay_ability, concat( round(count(if(overdue_days is not null, 1, null)) * 100 / count(*),1), "%" ) as ove...

2025-11-16

0 51

题解 | 统计加班员工占比

select department, concat( cast( round( count( if( timestampdi...

2025-11-16

0 42

题解 | 统计骑手信息

with temp0 as ( select z.zone_id, count(*) as peak_2024_02_delivered, round( sum(times...

2025-11-16

0 44

题解 | 分析每个商品在不同时间段的销售情况

with temp0 as ( select pi.product_id, sum(if(order_date between '2024-04-01' and '2024-06-30',total_amount,0)) as q2_2...

2025-10-12

0 29

题解 | 统计创作者

with temp0 as ( select max(publish_ts) as lastest_publish_time from post ) select t.author_id, author_name, posts_30d, likes_...

2025-10-12

0 31

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

with temp0 as ( select staff_id from delivery_records dr group by staff_id hav...

2025-10-04

0 49