Lateral

分类

/ 注册

全部文章（共129篇）

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

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 5

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

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 9

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

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 9

题解 | 平均播放进度大于60%的视频类别

with t as( select i.tag, case when timestampdiff(second,p.start_time,p.end_time)*100/i.duration>=100 t...

2025-10-14

0 7

题解 | 各个视频的平均完播率

select video_id, round(sum(ifcomp)/count(distinct uid),3) avg_comp_play_rate from( select v.video_id, v.uid, if(ti...

2025-10-14

0 7

题解 | 最受欢迎的top3课程

select c.cid, count(uid) as pv, sum(timestampdiff(minute,start_time,end_time)) as time_len from play_record_tb p right join course_info_tb...

2025-10-13

0 8

题解 | 目标月份的品类销售简报

select category, orders_cnt, buyers_cnt, items_qty, revenue, ifnull(round(revenue/orders_cnt,2),0) avg_order_value, rank()...

2025-09-26

0 18

题解 | 统计创作者

with t as ( select author_id, count(distinct title) posts_30d, sum(like_cnt) likes_30d from ...

2025-09-26

0 14

题解 | 近7天骑手履约时效看板

with t1 as( select max(delivered_ts) as latest_dt from parcel), t2 as( select p.courier_id, c.courier_name, c.cit...

2025-09-26

0 16

题解 | 最畅销的SKU

with tmp as( select i.store_id, i.store_name, i.city, t.sku_id, coalesce(round(sum(s.qty),2),0) as last7d_...

2025-09-24

0 10