cantin

分类

题解(2)

/ 注册

全部文章（共13篇）

题解 | 统计借阅量

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

2025-11-19

0 8

题解 | 分析客户逾期情况

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

2025-11-16

0 9

题解 | 统计加班员工占比

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

2025-11-16

0 9

题解 | 统计骑手信息

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

2025-11-16

0 10

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

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 6

题解 | 统计创作者

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 5

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

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

2025-10-04

0 14

题解 | 哪些产品在特定时间段内表现最为出色

select t.product_id, p.product_name, total_sales_amount, total_sales_quantity from ( select p.product_id, ...

2025-10-03

0 12

题解 | 对商品的销售情况进行深度分析

with temp0 as ( select category as product_category, age_group, sum(price * quantity) as total_sales_a...

2025-10-03

0 15

题解 | 电商平台想要了解不同商品在不同月份的销售趋势

select t.product_id, product_name, total_sales, max_monthly_sales, min_monthly_sales, avg_monthly_sales from ( sel...

2025-10-03

0 15