题解 | #返回顾客名称和相关订单号以及每个订单的总价#
看到这个2个表加上中间表一张，想到3个方式，分别为子查询（好理解），内连接（如下展示），隐式内连接（采用传统的where 加上比较 实现）。 tips： 1. 牛客这里表名称得按照规定来，此题大写首字母Customers 3表内连接 SELECT c.cust_name, o.order_num, (o.quantity * o.item_price) AS 'OrderTotal' FROM Customers AS c INNER JOIN Orders AS oc ON c.cust_id = oc.cust_id INNER JOIN OrderItems AS o ON oc.order_num = o.order_num ORDER BY c.cust_name,o.order_num asc;
查看10道真题和解析