牛客637883741号

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | #确定最佳顾客的另一种方式（二）#

select cust_name, sum(item_price*quantity) as total_price from Orders inner join OrderItems on OrderItems.order_num=Orders.order_num inner join Cust...

Mysql

2022-05-06

0 251

题解 | #返回每个顾客不同订单的总金额#

自测输入 DROP TABLE IF EXISTS `OrderItems`; CREATE TABLE IF NOT EXISTS `OrderItems`( order_num VARCHAR(255) NOT NULL COMMENT '商品订单号', item_price INT(16)...

Mysql

2022-05-06

0 260