马国成好样的

分类

/ 注册

全部文章（共51篇）

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

with od as( select o.order_id,category_id ,order_amount,order_date,customer_gender from order_details o left join customer_info c on o.order_id = c.or...

2025-07-11

0 52

题解 | 物流公司想要分析快递小哥的薪资构成和绩效情况

select c.courier_id , courier_name , sum(base_salary+delivery_fee-expense_amount) total_income from couriers_info c left join (select courier_id,...

2025-07-11

0 43

题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

select s.brand_id , brand_name , round(sum(return_status)/count(*),2) return_rate_July_2024 , round(avg(customer_satisfaction_score),2) average_custom...

2025-07-10

0 42

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

select performance.employee_id , employee_name , performance_score first_half_2024_score , row_number() over(partition by project_name order by perfor...

2025-07-10

0 51

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

with t1 as( select p.product_id , rank() over(partition by category order by total_amount desc ) category_rank from product_info p left join (sel...

2025-07-10

0 37

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

with t1 as( select s.product_id , product_name , sum(quantity) total_sales from sales_underline s left join products_underline p on s.product_id = p.p...

2025-07-10

0 43

题解 | 电商平台需要对商家的销售业绩、退款情况和客户满意度进行综合评估

with sl as( select merchant_id , sum(sale_amount) total_sales_amount from sales_underline group by 1 ) , avg as( select merchant_id ,round(avg(satisf...

2025-07-09

0 25

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

select category product_category , age_group , sum(quantity*price) total_sales_amount , round(sum(quantity*price)/sum(sum(quantity*price)) over(partit...

2025-07-09

0 34

题解 | 最受欢迎的top3课程

select c.cid ,count(p.cid) ,sum(timestampdiff(minute,start_time,end_time)) time_len from play_record_tb p left join course_info_tb c on p.cid = c.cid ...

2025-07-09

0 41

题解 | 未下单用户登陆渠道统计

select channel,count(distinct uid) cnt from user_info where uid not in ( select uid from order_log) group by 1 order by 1 limit 1

2025-07-09

0 30