题解 | #返回顾客名称和相关订单号以及每个订单的总价#
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
看了下其他人的解题,感觉这道题不需要group by 吧?下面是我的
select c.cust_name,a.order_num,(quantity*item_price) as OrderTotal from OrderItems a ,Orders b ,Customers c where a.order_num = b.order_num and b.cust_id = c.cust_id order by c.cust_name,b.order_num asc;
查看7道真题和解析
