shenggong

分类

题解(49)

/ 注册

全部文章（共12篇）

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

SELECT a.cust_id,b.total_ordered FROM Orders a INNER JOIN (SELECT order_num,SUM(item_price*quantity) AS total_ordered FROM OrderItems GROUP BY order_n...

Mysql

2022-03-11

12 784

题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）#

SELECT c.cust_email FROM Customers c, (SELECT a.prod_id,a.order_num,b.cust_id FROM OrderItems a INNER JOIN Orders b ON a.order_num=b.order_num WHERE a...

Mysql

2022-03-11

1 554