cantin

分类

题解(3)

/ 注册

全部文章（共18篇）

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

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

2025-12-27

0 13

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

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

Mysql

2025-12-23

0 15

题解 | 最畅销的SKU

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

2025-12-15

0 20

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

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

2025-12-02

0 22

题解 | 每个月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 22

题解 | 分析客户逾期情况

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

2025-11-16

0 18

题解 | 统计加班员工占比

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

2025-11-16

0 19

题解 | 统计骑手信息

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

2025-11-16

0 20

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

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 11