误清秋

分类

/ 注册

全部文章（共21篇）

题解 | 最畅销的SKU

WITH max_date AS ( SELECT MAX(snapshot_date) AS max_dt FROM store_stock_ ), lsb as (SELECT ss.store_id, ss.sku_id, sum(case when t.qty is null th...

2026-04-23

0 7

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

with lsb1 as (select cc.class_id, cc.course_id, cc.teacher_id, count(student_id) as learners_enrolled from course_class_ cc join course_enroll_ ce on...

2026-04-22

0 7

题解 | 下单复盘

with lsb1 as ( select c.customer_id, c.customer_name, sum( case wh...

2026-04-21

0 5

题解 | 精品咖啡连锁门店王牌产品及其最忠实顾客分析

with lsb1 as ( select c.shop_id, shop_name, city, product_name, sum(quantity*unit_price) as product_r...

2026-04-21

0 7

题解 | 精品咖啡连锁门店王牌产品及其最忠实顾客分析

with lsb1 as ( select c.shop_id, shop_name, city, product_name, sum(quantity*unit_price) as product_r...

2026-04-20

0 8

题解 | SaaS产品租户核心功能模块用量及占比分析

with lsb1 as (select tenant_name, plan_type, sum(call_count) as zongs from tenants t join usage_logs u on t.tenant_id = u.tenant_id group by tenant_n...

2026-04-20

0 9

题解 | 分析客户逾期情况

with lsb as (select ct.pay_ability, count(*) as total from loan_tb lt join customer_tb ct on lt.customer_id = ct.customer_id group by ct.pay_ability...

2026-04-08

0 29

题解 | 获取指定客户每月的消费额

select date_format(t.t_time, '%Y-%m') as time, sum(t_amount) as total from trade t join customer c on t.t_cus = c.c_id where c.c_name = 'Tom' and yea...

2026-04-08

0 22

题解 | 统计商家不同会员每日访问人次及访问人数

select ut.vip, count(*) as visit_nums, count(distinct vt.user_id) as visit_users from visit_tb vt join uservip_tb ut on vt.user_id = ut.user_id gro...

2026-04-08

0 17

题解 | 游戏平台新玩家消费与进阶行为分析

select p.player_id, p.username, p.level as current_level, (case when p.level >= 30 then '高阶玩家' else '新秀玩家' end) as player_category, l.total_april_...

2026-03-24

0 29