牛客987852806号

分类

题解(45)

/ 注册

全部文章（共182篇）

题解 | 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 12

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

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 7

题解 | 基本数学函数

--简单题 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 23

题解 | 计算每日累计利润

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

2026-01-30

0 21

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

--简单题 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

0 23

题解 | 近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 32

题解 | 最畅销的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 28

题解 | 下单复盘

--分解做法，容易看懂 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 30

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

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

2025-12-17

0 37

题解 | 统计骑手信息

--比较容易理解的拆解方法。 with tiaojian as ( select zs.zone_id, zs.zone_name, count(distinct case when date_format(delivered_time,"%Y%m")=202302 then...

2025-12-03

0 32