牛牛菌不是男娘

分类

/ 注册

全部文章（共59篇）

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

select p.product_id product_id ,product_name ,sum(ifnull(total_amount,0)) q2_2024_sales_total ,dense_rank()over(partition by category order by sum(tot...

2025-09-08

0 0

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

select t1.merchant_id merchant_id ,merchant_name ,total_sales_amount ,total_refund_amount ,average_satisfaction_score from (select merchant_id ,merch...

2025-09-08

0 0

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

with t as ( select category ,sum(quantity * price) category_total_sales from sales s join products p on s.product_id = p.prod...

2025-09-08

0 0

题解 | 最受欢迎的top3课程

select pt.cid cid ,count(*) pv ,sum(timestampdiff(minute, start_time, end_time)) time_len from play_record_tb pt join course_info_tb ct on pt.cid = ct...

2025-09-08

0 0

题解 | 更新员工信息表

with EMPLOYEE_INFO2 as (select EMPLOYEE_ID ,UPDATE_DT ,NEW_POSITION from ( select EMPLOYEE_ID ,UPDATE_DT ,NEW_POSITION ,rank()ov...

2025-09-08

0 0

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

select channel ,cnt from( select channel ,count(*) cnt ,rank()over(order by count(*) desc, channel) rk from user_info where ui...

2025-09-08

0 0

题解 | 每个顾客购买的最新产品名称

select customer_id ,customer_name ,latest_order from ( select o.customer_id customer_id ,customer_name ,product_name latest_order ...

2025-09-08

0 8

题解 | 各个部门实际平均薪资和男女员工实际平均薪资

with t as ( select department ,round(avg(normal_salary - dock_salary), 2) average_actual_salary from staff_tb stt join salary_tb s...

2025-09-08

0 5

题解 | 统计每个产品的销售情况

解题思路难点在于统计单月最高销量（max_monthly_quantity）和购买量最多的客户年龄段（customer_age_group）字段。这两个字段需要单独开一个表来统计。因此，本人的解法是：表一统计product_id, total_sales, unit_price, total_qua...

2025-09-08

0 8

题解 | 商品销售总额分布

select if(pay_method = '','error', pay_method) pay_method, num from ( select pay_method ,count(*) num from user_client_log u join ...

2025-09-07

0 6