with b as ( -- 为每个人的订单时间排序,取第一单编号 select distinct order_id from (select distinct row_number()over(partition by uid order by event_time) as rk,order_id from tb_order_overall )t1 where rk=1 ), a as ( -- 根据b查询出的第一单编号,计算总支付价和原价(原价需要sum) select uid,a.total_amount,sum(b.price*b.cnt) as ori_price from tb_o...