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

with fo as(
    select uid, total_amount, order_id, status from tb_order_overall a where event_time = (select min(event_time) from tb_order_overall o group by o.uid
    having a.uid = o.uid) and month(event_time) = 10
)
, ordersum as(
    select order_id, sum(price*cnt) as s from tb_order_detail
    group by 1
)
select round(avg(total_amount),1), round(avg(s -total_amount),1) from ordersum o left join fo f using(order_id)

写起来觉得卡手