Lateral

分类

/ 注册

全部文章（共146篇）

题解 | 平均播放进度大于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 29

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

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 36

题解 | 最受欢迎的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 37

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

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

2025-09-26

2 59

题解 | 统计创作者

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

2025-09-26

0 53

题解 | 近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

1 63

题解 | 最畅销的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

1 29

题解 | 医院门诊复诊率与抗生素用药占比统计

with t1 as( select dept, coalesce(count(visit_id),0) as feb_2024_visits, coalesce(count(distinct patient_id),0) as feb_202...

2025-09-24

0 43

题解 | 下单复盘

select c.customer_id, c.customer_name, coalesce(count(distinct o.order_id),0) as feb_2024_order_count, coalesce(sum(i.qty*i.price),0) ...

2025-09-23

0 50

题解 | 统计骑手信息

with t1 as( select o.zone_id, z.zone_name, sum(if(left(o.order_time,7)='2023-02' and hour(o.order_time) in(11,12,13,18,19...

2025-09-19

0 42