题解 | 返回每个顾客不同订单的总金额
SELECT cust_id, ( SELECT SUM(item_price*quantity)
FROM OrderItems
WHERE OrderItems.order_num=Orders.order_num ) AS total_ordered
FROM Orders
ORDER BY total_ordered DESC;
SUM()计算满足WHERE条件的列值之和
01-12 15:26 浙江大学附属中学 算法工程师 发布于上海
关注
投递大疆等公司10个岗位
查看15道真题和解析