重生之各大厂争着抢我

分类

/ 注册

全部文章（共48篇）

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

with avg_table as ( select c1.user_id, round(avg(rating),2) as average_rating from content_reviews c1 join course_completions...

2026-03-11

0 54

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

with a as( select class_id, count(student_id) as learners_enrolled from course_enroll_ group by class_id ), b as( s...

2026-01-15

0 59

题解 | 最畅销的SKU

with a as( select ss.store_id, store_name, city, ss.sku_id, ifnull(sum(qty),0) as last7d_qty, ifn...

2026-01-15

0 55

题解 | 查询连续登陆的用户

with a as( select user_id, date(log_time) as time, rank() over(partition by user_id order by date(log_time)) as rk fr...

2026-01-15

0 61

题解 | 统计每个产品的销售情况

# 产品ID（product_id）：产品的ID。 # 总销售额（total_sales）：该产品的2023年总销售额。 # 单价（unit_price）：产品的单价。 # 总销量（total_quantity）：该产品的2023年总销售数量。 # 月平均销售额（avg_monthly_sales）...

2026-01-15

0 62

题解 | 统计所有课程参加培训人次

select number1+number2+number3 as staff_nums from ( select sum(case when course like '%1%' then 1 else 0 end ) as number1, ...

2026-01-14

0 62

题解 | 最长连续登录天数

with a as( select *, rank() over(partition by user_id order by fdate) as rk from tb_dau where fdate between '2023-01-01' ...

2026-01-14

0 46

题解 | 下单复盘

with a as( select c.customer_id, customer_name, count(distinct order_id) as feb_2024_order_count, round(sum(qty*p...

2026-01-14

0 44

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

with a as( select campaign_id, campaign_name, sum(case when date_format(event_time,'%Y-%m')='2023-02' then 1 else 0 end) ...

2026-01-14

0 62

题解 | 统计借阅量

with a as( select book_id, book_title, sum(case when date_format(borrow_date,'%Y-%m')='2023-02' then 1 else 0 end) as feb...

2026-01-13

0 51