题解 | #返回顾客名称和相关订单号以及每个订单的总价#

select C.cust_name,O.order_num,sum(OI.quantity * OI.item_price) as OrderTotal
from Customers as C
inner join Orders as O
on O.cust_id = C.cust_id
inner join OrderItems as OI
on OI.order_num = O.order_num
group by C.cust_name,O.order_num
order by C.cust_name asc ,O.order_num;

程序异常退出, 请检查代码"是否有数组越界等异常"或者"是否有语法错误"

SQL_ERROR_INFO: "Unknown database 'test'

又出现这样的报错，去必应了几分钟没找到原因

回来重新提交又ac了

牛客oj真是神奇