cantin

分类

题解(3)

/ 注册

全部文章（共18篇）

题解 | 统计创作者

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 11

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

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

2025-10-04

0 24

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

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

2025-10-03

0 20

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

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

2025-10-03

0 24

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

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

2025-10-03

0 20

题解 | 最受欢迎的top3课程

select ci.cid, count(*) as pv, sum(timestampdiff(MINUTE, start_time, end_time)) as time_len from course_info_tb ci inner join play...

2025-10-03

0 22

题解 | 分析每个员工在不同项目中的绩效情况

select e.employee_id, employee_name, performance_score as first_half_2024_score, row_number()over( partition by pf.project_id...

2025-09-30

0 25

题解 | 查询出每个运输方式在不同城市的平均运输时长以及总运输费用

select destination_city, transport_name, round(sum(timestampdiff(day,order_date,delivery_date))/count(*),2) as average_transport_duratio...

2025-09-30

0 17