呼吸丶zero

分类

/ 注册

全部文章（共42篇）

题解 | 微服务架构下的深层依赖链路漏洞影响面分析

WITH RECURSIVE temp as ( select caller_service_id ,s1.service_name as s1_name ,callee_service_id ,s2.service_name as s2_name ,...

2026-04-18

0 10

题解 | 在线教育平台活跃学员课程评价分析

select cc.user_id ,round( sum( if( cr.course_id = 'DS-102', rating, 0) ) / sum( if( cr.course_id = 'DS-102', 1, 0) ), 2 ) as average_rating ,if( round...

2026-04-12

0 26

题解 | 统计骑手信息

WITH A as ( select zone_id ,zone_name ,sum( if( date_format( delivered_time,'%Y-%m') = '2023-02' and (HOUR( order_time) in (11,12,13,18,19...

2026-01-27

0 78

题解 | 统计借阅量

select book_id, book_title, ifnull( count( case when borrow_date between '2023-02-01' and '2023-02-28' then record_id end ),0) as feb_2023_borrows, if...

2026-01-27

0 55

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

WITH A as ( select campaign_id, campaign_name, count( case when ev...

2026-01-26

0 57

题解 | 下单复盘

SELECT c.customer_id, c.customer_name, IFNULL(COUNT(DISTINCT o.order_id), 0) AS feb_2024_order_count, ROUND(IFNULL(SUM(oi.qty * oi.pri...

2026-01-26

0 61

题解 | 医院门诊复诊率与抗生素用药占比统计

WITH T1 as ( select dept, count(distinct visit_id) as feb_2024_visits, count(distinct patient_id) as f...

2026-01-25

0 84

题解 | 统计每个班级的关键指标

select cc.class_id, course_id, teacher_id, learners_enrolled, ifnull(learners_active_m, 0) as learners_active_m, ifnull(finish...

2026-01-22

1 78

题解 | 最畅销的SKU

select * from ( select ss.store_id, store_name, city, ss.sku_id, case ...

2026-01-04

0 69

题解 | 获得积分最多的人(三)

select user_id as id ,name ,grade_num from ( select user_id ,sum( case when type = 'add' then grade_num when t...

2025-08-13

0 86