Lateral

分类

/ 注册

全部文章（共146篇）

题解 | 工作日各时段叫车量、等待接单时间和调度时间

with t1 as( select o.order_id, case when time(r.event_time)>='07:00:00' and time(r.event_time)<'09:00:00' then ...

2026-02-09

0 19

题解 | 国庆期间近7日日均取消订单量

with t1 as( select '2021-10-01' as dt, round(count(fare)/7,2) as finish_num_7d, round((count(*)-count(fare))/7,2) as cance...

2026-02-09

0 24

题解 | 每个城市中评分最高的司机信息

with t1 as( select r.city, o.driver_id, o.order_id, date_format(o.order_time,'%Y-%m-%d') as order_dt, o.mi...

2026-02-05

0 24

题解 | 2021年国庆在北京接单3次及以上的司机统计信息

with t1 as( select o.order_id, o.uid, o.driver_id, r.event_time, r.end_time, o.order_time, ...

2026-02-05

0 29

题解 | 店铺901国庆期间的7日动销率和滞销率

我这个句子跑出来，动销率和滞销率都对得上，只是没有保留三位小数，但一旦用round保留3位小数，就报错显示10/2的动销率和滞销率数据缺失，问了豆包、ds都解答不了原因，各种办法调试、也想了很久都没有搞懂是为啥，遂放弃，就这样吧。有遇到过相同问题或知道原因的大佬，期待解惑~witht1 as( ...

2026-02-05

0 37

题解 | 10月的新户客单价和获客成本

with t0 as( select distinct uid from tb_order_overall where date_format(event_time,'%Y%m')='202110'), t1 as( select distinct uid ...

2026-01-14

0 32

题解 | 零食类商品中复购率top3高的商品

with t0 as( select a.product_id, b.uid, date(b.event_time) as dt from tb_order_detail a left join tb_order_overal...

2026-01-14

0 30

题解 | 某店铺的各商品毛利率及店铺整体毛利率

with t0 as( select a.order_id, a.product_id, c.in_price, a.price, a.cnt from tb_order_detail a lef...

2026-01-14

0 37

题解 | 统计2021年10月每个退货率不大于0.5的商品各项指标

select product_id, coalesce(round(sum(if_click)/count(if_click),3),0) ctr, coalesce(round(sum(if_cart)/sum(if_click),3)) cart_rate, co...

2026-01-13

0 33

题解 | 计算商城中2021年每月的GMV

with t0 as( select date_format(event_time,'%Y-%m') as month, total_amount from tb_order_overall where year(event_time)=202...

2026-01-13

0 40