Lateral

分类

/ 注册

全部文章（共146篇）

题解 | 连续签到领金币

with t0 as( select uid, concat(left(date,4),substr(date,6,2)) as month, case (dense_rank() over(partition by uid,dt_rn ord...

2026-01-13

0 29

题解 | 每天的日活数及新用户占比

继续笨办法，一步一步推 -------------------- with t1 as( select dt from ((select date(in_time) as dt from tb_user_log group by date(in_time)) uni...

2025-12-09

0 35

题解 | 统计活跃间隔对用户分级结果

笨办法，一步一步推 ----------------- with t1 as( select dates from ((select date(in_time) as dates from tb_user_log group by date(in_time)) un...

2025-12-08

0 34

题解 | 2021年11月每天新用户的次日留存率

with t1 as(---11月所有活跃日期 select dates from ((select date(in_time) as dates from tb_user_log group by date(in_time)) union ...

2025-12-05

0 37

题解 | 每篇文章同一时刻最大在看人数

with t1 as( select artical_id,time from( select artical_id,in_time as time from tb_user_log union all select a...

2025-10-22

0 47

题解 | 2021年11月每天的人均浏览文章时长

select dt, round(sum(view_len)/count(distinct uid),1) avg_viiew_len_sec from( select date(in_time) dt, uid, if(ar...

2025-10-22

0 39

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

with t as( select i.video_id, avg(timestampdiff(second,start_time,end_time)>=i.duration) full_play_rate, sum(if_like) l...

2025-10-22

0 36

题解 | 国庆期间每类视频点赞量和转发量

with t1 as( select i.tag, date_format(p.start_time,'%Y-%m-%d') as dt, sum(p.if_like) as like_cnt, sum(p.if_retwee...

2025-10-20

0 39

题解 | 每个创作者每月的涨粉率及截止当前的总粉丝量

with t1 as( select i.author, date_format(p.start_time,'%Y-%m') as month, case when p.if_follow=1 then 1 ...

2025-10-15

0 58

题解 | 每类视频近一个月的转发量/率

with t1 as( select i.tag, p.video_id, date_format(p.start_time,'%Y-%m-%d') pdate, p.if_retweet from ...

2025-10-15

0 45