题解 | 更新用户积分信息？
with tmp as ( select t.user_id,sum(t.order_price) as total from ( select user_id,order_price from order_tb where order_price > 100) as t group by t.user_id) select t1.user_id,(t1.total + t2.point) as point from tmp as t1 left join uservip_tb as t2 on t1.user_id = t2.user_id order by point desc;
亲身经历，我本科还是985，就业不算差的那种，然而我们那届考研率70%保研率20%
投递牛客等公司8个岗位 >
字节跳动成长空间 616人发布