返回顾客名称和相关订单号以及每个订单的总价
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select
cust_name,
order_num,
sum(quantity*item_price) as OrderTotal
from
OrderItems as main inner join Orders as a using(order_num)
inner join Customers as b using(cust_id)
group by cust_name,order_num
order by cust_name,order_num
真的是验证了只要肯吃苦就有吃不完的苦这句话。。
吉比特公司福利 223人发布