题解 | 统计各等级会员用户下订单总额
统计各等级会员用户下订单总额
https://www.nowcoder.com/practice/48dd35a3dd8c4e1494db36b097a03300
with a as(select vip, if(order_price is null,0,order_price) as order_price from uservip_tb as a left join order_tb as b on a.user_id = b.user_id) select vip, sum(order_price) as order_total from a group by vip order by order_total desc
投递哔哩哔哩等公司6个岗位