牛客134017745号

分类

/ 注册

全部文章（共28篇）

题解 | 统计借阅量

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

2025-10-30

0 7

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

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 17

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

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

2025-10-12

0 16

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

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

2025-10-07

0 18

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

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

2025-10-07

0 17

题解 | 连续签到领金币

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

2025-10-06

0 16

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

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

2025-10-02

0 17

题解 | 统计借阅量

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 22

题解 | 2021年国庆在北京接单3次及以上的司机统计信息

with valid_order as ( select t1.city as city, t2.driver_id as driver_id, count(t2.order_id) as order_num, sum(ifnu...

2025-05-28

0 53

题解 | 近一个月发布的视频中热度最高的top3视频

with t1 as ( select t1.video_id, avg(if(timestampdiff(second, start_time, end_time)>=duration, 1, 0)) as finish_rate, s...

2025-04-24

0 58