呼吸丶zero

分类

/ 注册

全部文章（共42篇）

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

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

2025-08-10

0 111

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

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

2025-08-10

0 96

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

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 81

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

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 100

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

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

2025-07-27

0 96

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

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 81

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

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

2025-07-26

0 119

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

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

2025-07-25

1 96

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

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

2025-07-24

14 107

题解 | 查询出每个品牌在不同月份的总销售额以及购买该品牌商品的用户的平均年龄

select category_id ,sum(order_amount) as total_sales ,sum(case when customer_gender = '男' then 1 else 0 end) as male_customers ,sum(case when customer...

2025-07-23

0 87