牛客134017745号

分类

/ 注册

全部文章（共30篇）

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

with latest_review as ( select user_id, date(max(review_date)) as latest_review_date from content_reviews group by user_...

2026-02-11

0 40

题解 | 智能家居设备高能耗异常监控分析

with device_sum as ( select category, device_name, t1.device_id, location, round(sum(usage_kwh), 2) as tot...

2026-02-11

0 38

题解 | 统计借阅量

with borrows_data as( select book_id, feb_2023_borrows, feb_2024_borrows, jan_2024_borrows, (feb_2024_borr...

2025-10-30

0 35

题解 | 每个题目和每份试卷被作答的人数和次数

select * from (select exam_id as tid, count(distinct uid) as uv, count(*) as pv from exam_record group by exam_id order by uv desc, pv de...

2025-10-13

0 52

题解 | 月总刷题数和日均刷题数

select * from ( ( select submit_month, month_q_cnt, round(month_q_cnt/month_cnt,3) as avg_day_q_cnt ...

2025-10-12

0 38

题解 | 店铺901国庆期间的7日动销率和滞销率

# 窗口函数不能用DISTINCT，只能用子查询搜索和每天相近七天有销量的商品数目!!!!!!!!!! select dt, round(sales_amount/total_amount, 3) as sale_rate, round(1-sales_amount/tota...

2025-10-07

0 43

题解 | 店铺901国庆期间的7日动销率和滞销率

# 窗口函数不能用DISTINCT，只能用子查询搜索和每天相近七天有销量的商品数目!!!!!!!!!! select dt, round(sales_amount/total_amount, 3) as sale_rate, round(1-sales_amount/tota...

2025-10-07

0 37

题解 | 连续签到领金币

select uid, month, sum(coin) as coin from ( select uid, month, ( case when (cons_days <...

2025-10-06

0 44

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

with conv_cnt as ( select c.campaign_id, sum( case when date_format(event_time, '%Y-%m') = '2023-02' then ...

2025-10-02

1 51

题解 | 统计借阅量

with borrows_cnt as( select b.book_id, sum( case when date_format(borrow_date, '%Y-%m')='2023-02' then 1 e...

2025-09-27

0 59