呼吸丶zero

分类

/ 注册

全部文章（共33篇）

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

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 33

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

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

2025-08-10

0 34

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

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

2025-08-10

0 37

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

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 30

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

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 41

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

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

2025-07-27

0 43

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

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 38

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

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

2025-07-26

0 44

题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

select employee_id ,department_name ,performance_score from ( select employee_id ,department_name ,performance_score ,avg(performance_...

2025-07-25

0 44

题解 | 电商平台需要对商品的销售和评价情况进行综合分析

select product_id, product_name, sum(quantity) as total_quantity, round(average_rating, 2) as average_rating from sales_underline ...

2025-07-24

6 58