cantin

分类

题解(3)

/ 注册

全部文章（共19篇）

题解 | 近7天骑手履约时效看板

with temp0 as ( select max(delivered_ts) as benchmark_day from parcel ), temp1 as ( select p.courier_id, count(*) as orde...

2026-01-10

0 6

题解 | 统计每个产品的销售情况

with temp0 as ( select product_id, date_format(order_date, "%Y-%m") as date, sum(quantity) a...

2025-12-27

0 16

题解 | #查询单日多次下订单的用户信息？#

select order_date, t.user_id, order_nums, vip from ( select user_id, date_format(order_time, "%Y-%...

Mysql

2025-12-23

0 16

题解 | 最畅销的SKU

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

2025-12-15

0 21

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

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

2025-12-02

0 23

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

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

2025-11-25

0 16

题解 | 统计借阅量

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

2025-11-19

0 23

题解 | 分析客户逾期情况

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

2025-11-16

0 19

题解 | 统计加班员工占比

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

2025-11-16

0 21

题解 | 统计骑手信息

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

2025-11-16

0 21