牛客987852806号

分类

题解(45)

/ 注册

全部文章（共183篇）

题解 | SaaS产品高价值用户活跃度分析

--您在里面看呢，这解法简单，分解解法 --1.筛选题干的条件，2025年上半年注册的,PRO的用户 with tiaojian1 as ( select user_id, user_name from users where date(registration_date) between '20...

2026-05-13

0 19

题解 | SaaS平台企业客户新功能采纳度分析

--有点神经的做法了 with tiaojian as ( select team_id, team_name from teams where plan_level='Enterprise' ),tiaojian1 as ( select t.team_id, t.team_name, c...

2026-02-25

0 100

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

with tiaojian as( select user_id, course_id, completion_date from course_completions where date_format(completion_date,'%Y%m')=202503 and course_id=...

2026-02-25

0 82

题解 | 基本数学函数

--简单题 select id, value, abs(value) as absolute_value, ceiling(value) as ceiling_value, floor(value) as floor_value, round(value,1) as rounded_value...

2026-01-30

1 78

题解 | 计算每日累计利润

--简单题 select profit_id, profit_date, profit, sum(profit)over(order by profit_date) as cumulative_profit from daily_profits

2026-01-30

0 72

题解 | 目标月份的品类销售简报

--简单题 select p.category, count(distinct os.order_id) as orders_cnt, count(distinct od.buyer_id) as buyers_cnt, sum(qty) as items_qty, sum(qty*pric...

2026-01-30

1 74

题解 | 近7天骑手履约时效看板

--比较简单吧 select c.courier_id, c.courier_name, c.city, count(parcel_id) as orders_7d, count(distinct case when timestampdiff(minute,shipped_ts,delivere...

2026-01-26

0 102

题解 | 最畅销的SKU

--连表需要注意，不能直接连，看好关系 --这段求last7d_qty，avg_daily_qty，stock_qty with tiaojian as ( select sf.store_id, sf.store_name, sf.city, st.sku_id, ifnull(sum(qty)...

2026-01-21

0 84

题解 | 下单复盘

--分解做法，容易看懂 with tiaojian as ( select cs.customer_id, cs.customer_name, count(distinct os.order_id ) as feb_2024_order_count, ifnull(sum(qty*price),0)...

2025-12-17

0 85

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

--出题的人太缺德了，我真都后两问没明白啥意思，能说点普通话吗？ with tiaojian as ( select e.campaign_id, cs.campaign_name, count(distinct case when date_format(event_time,"%Y...

2025-12-17

0 90