白色森林

分类

/ 注册

全部文章（共49篇）

题解 | 评估2023年不同品牌商品的销售趋势和客户满意度

SELECT s.brand_id, SUM(s.sales_amount) AS total_sales_amount, SUM(s.sales_quantity) AS total_sales_quantity, ROUND(AVG(c.satisfaction_...

2025-08-20

1 21

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

SELECT b.brand_id, b.brand_name, ROUND(SUM(s.return_status)/COUNT(*),2) AS return_rate_July_2024, ROUND(AVG(c.customer_satisfaction_sc...

2025-08-20

2 22

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

SELECT u.channel, CAST(SUM(CASE WHEN o.order_id IS NULL THEN 1 ELSE 0 END) AS SIGNED) AS cnt FROM user_info AS u LEFT JOIN order_log AS o ...

2025-08-19

1 24

题解 | 支付间隔平均值

SELECT CAST(AVG(ABS(TIMESTAMPDIFF(SECOND,o.logtime,s.logtime))) AS SIGNED) FROM order_log AS o INNER JOIN select_log AS s ON o.order_id=s...

2025-08-19

1 21

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

SELECT c.name AS customer_name, SUM(p.price) AS total_travel_cost, COUNT(b.id) AS order_count, ROUND(AVG(p.price),2) AS avg_order_pric...

2025-08-19

1 31

题解 | 每天登陆最早的用户的内容喜好

SELECT DATE(ltr.log_time) AS log_day, ltr.user_id, u.hobby FROM ( SELECT log_time, user_id, ...

2025-08-19

1 29

题解 | 每个顾客最近一次下单的订单信息

WITH order_date_rank AS ( SELECT o.order_id, c.customer_name, o.order_date, ROW_NUMBER() OVER (PARTITION BY o.cust...

2025-08-19

1 22

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

WITH oppototal AS ( SELECT opd.product_id, opd.product_name, SUM(si.quarter_1_sales_amount+si.quarter_2_sales_amount+si.qu...

2025-08-19

1 27

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

SELECT op.product_line, sc.region, sc.channel_name, SUM(sd.sale_amount) AS total_sale_amount, COUNT(sd.sale_id) AS total_sale_quan...

2025-08-19

1 23