木流_牛马
木流_牛马
全部文章
分类
归档
标签
去牛客网
登录
/
注册
木流_牛马的博客
全部文章
(共23篇)
题解 | 每天的日活数及新用户占比
#rihuo == mei tian , distinct, yonghuzongshu #xinyonghu zhanbi=dangtian xinyonghu /rihuo with tnew as ( select date(tb.in_time) as date_in_time,co...
2025-04-12
0
29
题解 | 计算商城中2021年每月的GMV
#shengxu #2021nian #meiyue #gmv>10w shuchu # gmv shi 0 +1 #baoliuzhengshu select date_format(event_time,'%Y-%m') as month,round(sum(total_amount),0...
2025-04-12
0
29
题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量
#2021 #per creater per month #growth nb(jiafeng-diaofeng) growth rate(growth nb / bofang) (round 3) with fans_grow_nb as (select tbv.author as auth...
2025-04-11
1
29
题解 | 2021年11月每天新用户的次日留存率
with td as ( select id,uid,date(in_time) as indate,date(out_time) as outdate from tb_user_log ), tnew as ( select t.indate,count(t.uid) ...
2025-04-11
0
29
题解 | 平均播放进度大于60%的视频类别
with t1 as ( select tbv.video_id as video_id,tbv.tag as tag, sum(least(time_to_sec(timediff((time(tbu.end_time)),time((tbu.start_time)))),tbv.dura...
2025-04-10
1
29
题解 | 每类视频近一个月的转发量/率
with T_tot_per_video as ( select tv.*, count(tu.uid) as tot_vue_perv,sum(coalesce(tu.if_retweet,0)) as tot_retweet_perv from tb_video_info tv left joi...
2025-04-07
0
29
题解 | 查找当前薪水详情以及部门编号dept_no
select d.emp_no as emp_no, s.salary as salary, s.from_date as from_date, s.to_date as to_date, d.dept_no as dept_no from dept_manager d left join sala...
2025-04-07
0
27
题解 | 找出每个学校GPA最低的同学
select u.device_id as device_id,u.university as university, u.gpa as gpa from (select * ,row_number() over (partition by ub.university order by ub.gpa...
2025-04-05
1
34
题解 | 统计各等级会员用户下订单总额
select u.vip as vip, coalesce(sum(o.order_price),0) as order_total from uservip_tb u left join order_tb o on u.user_id=o.user_id group by u.vip order ...
2025-04-05
0
33
题解 | 商品id数据清洗统计
select regexp_substr(o.order_id,"[^_]+$") as product_id, count(*) from order_log o group by product_id
2025-03-28
3
38
首页
上一页
1
2
3
下一页
末页