激动的大猩猩呀呼呀呼

分类

/ 注册

全部文章（共5篇）

题解 | 下单复盘

WITH t1 AS ( SELECT c.customer_id, c.customer_name, o.order_id, o.order_date, oi.sku, oi.qty, oi.price FROM cu...

2025-09-27

0 41

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

WITH t1 AS ( SELECT c.campaign_id, c.campaign_name, c.category, u.user_id, u.region, u.device, e.ev...

2025-09-27

0 38

题解 | 统计骑手信息

-- t1:总表 WITH t1 AS ( SELECT z.zone_id, z.zone_name, z.zone_type, o.order_time, o.delivered_time, o.status, o.fee, c.cou...

2025-09-26

4 29

题解 | 统计借阅量

WITH t1 AS ( SELECT b1.book_id, b1.book_title, b1.category, b2.branch_id, b2.borrow_date, b2.member_id, ...

2025-09-26

1 27

题解 | 贷款情况

CREATE VIEW t1 AS SELECT c.customer_id, c.customer_name, c.city, c.age, l.loan_am...

2025-09-26

1 33