牛客134017745号
牛客134017745号
全部文章
分类
归档
标签
去牛客网
登录
/
注册
牛客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
首页
上一页
1
2
3
下一页
末页