呼吸丶zero

分类

/ 注册

全部文章（共35篇）

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

select cc.class_id, course_id, teacher_id, learners_enrolled, ifnull(learners_active_m, 0) as learners_active_m, ifnull(finish...

2026-01-22

0 6

题解 | 最畅销的SKU

select * from ( select ss.store_id, store_name, city, ss.sku_id, case ...

2026-01-04

0 18

题解 | 获得积分最多的人(三)

select user_id as id ,name ,grade_num from ( select user_id ,sum( case when type = 'add' then grade_num when t...

2025-08-13

0 54

题解 | 牛客的课程订单分析(五)

select user_id ,date first_buy_date ,dt as second_buy_date ,cnt from ( SELECT user_id, date, ...

2025-08-10

0 66

题解 | 牛客的课程订单分析(五)

select user_id ,date first_buy_date ,dt as second_buy_date ,cnt from ( SELECT user_id, date, ...

2025-08-10

0 64

题解 | 查询高价值旅行套餐客户的支出与套餐详情

select c.name as customer_name ,SUM(price) as total_travel_cost ,count(*) as order_count ,ROUND(avg(price),2) as avg_order_price from bookings as b jo...

2025-07-27

0 48

题解 | 分析各产品线在特定时间段内的销售情况

select product_line ,region ,channel_name ,sum(sale_amount) as total_sale_amount ,count(*) as total_sale_quantity from sales_data join oppo_products u...

2025-07-27

0 63

题解 | 深入分析各款产品年总销售额与竞品的年度对比

select product_id, product_name, competitor_name, total_sales_amount_of_product, total_sales_amount_of_product - total_competitor_...

2025-07-27

0 58

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

select weather_type ,ROUND(avg(delivery_time),2) as average_delivery_time ,count(is_complaint) as delivery_count from delivery_records as dr join weat...

2025-07-27

0 54

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

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

2025-07-26

0 67