Sunshine晶晶

分类

/ 注册

全部文章（共86篇）

题解 | 内容社区用户活跃度、转化与广告归因分析

WITH t1 AS ( SELECT C.campaign_id, campaign_name, COUNT(CASE WHEN DATE_FORMAT(event_time,'%Y-%m')='2023-02' THEN event_id EN...

2026-02-26

0 38

题解 | 统计骑手信息

WITH t1 AS ( SELECT Z.zone_id,zone_name, COUNT(IF(DATE_FORMAT(order_time,"%Y-%m")='2023-02',order_id,NULL)) AS peak_2023_02_delivered...

2026-02-25

0 43

题解 | 统计借阅量

SELECT B1.book_id, book_title, SUM(IF(borrow_date BETWEEN '2023-02-01' AND '2023-02-28',1,0)) AS feb_2023_borrows, SUM(IF(borrow_...

2026-02-22

0 28

题解 | 贷款情况

WITH t1 AS ( SELECT city,loan_type_name,l1.loan_type_id, ROW_NUMBER() OVER(PARTITION BY city ORDER BY COUNT(loan_type_name) DESC , l1.l...

2026-02-19

0 33

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

SELECT weather_type, ROUND(AVG(delivery_time),2) AS average_delivery_time, COUNT(record_id) AS deliv...

2026-02-15

0 42

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

WITH t2 AS ( SELECT t1.product_id, product_name, category_id, sales_amount, ROUND((sales_amount-cost_amount)/sales_amount,...

2026-02-03

0 39

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

WITH t AS( SELECT p.product_id, p.product_name, COALESCE(SUM(total_amount),0) AS q2_2024_sales_total FROM order_info o ...

2026-02-02

0 49

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

WITH t1 AS ( SELECT merchant_id, SUM(sale_amount) AS total_sales_amount FROM sales_underline GROUP BY merchant_id ), t2 AS ( ...

2026-01-29

0 31

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

WITH t1 AS ( SELECT category,SUM(quantity*price) AS total_sales_amount FROM products p LEFT JOIN sales s ON p.product_id=s.product_id ...

2026-01-28

0 28

题解 | 最受欢迎的top3课程

SELECT p.cid, COUNT(uid) AS pv, SUM(TIMESTAMPDIFF(MINUTE,start_time,end_time)) AS time_len FROM play_record_tb p LEFT JOIN course_info_t...

2026-01-27

0 44