木流_牛马

分类

/ 注册

全部文章（共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