少糖去冰啊_

分类

/ 注册

全部文章（共61篇）

题解 | 返回产品名称和与之相关的订单号

SELECT prod_name, order_num FROM Products P LEFT JOIN OrderItems O on P.prod_id = O.prod_id ORDER BY prod_name

2025-10-15

0 11

题解 | 检索每个顾客的名称和所有的订单号（二）

SELECT cust_name, order_num FROM Customers C LEFT JOIN Orders O on C.cust_id=O.cust_id ORDER BY cust_name

2025-10-15

0 10

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

SELECT Cus.cust_name, sum(item_price*quantity) as total_price FROM OrderItems O1 RIGHT JOIN Orders Os on O1.order_num = Os.order_num LEFT JOIN Custome...

2025-10-14

0 11

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

SELECT cust_email FROM OrderItems O1 LEFT JOIN Orders Os on O1.order_num = Os.order_num LEFT JOIN Customers Cus on Os.cust_id = Cus.cust_id where O1.p...

2025-10-14

0 11

题解 | 确定哪些订单购买了 prod_id 为 BR01 的产品（二）

SELECT cust_id, order_date FROM OrderItems O1 LEFT JOIN Orders Ors on O1.order_num = Ors.order_num where prod_id ='BR01' ORDER BY order_date asc

2025-10-14

0 13

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

SELECT cus.cust_name, o1.order_num, OrderTotal from Orders o1 LEFT JOIN Customers cus on cus.cust_id = o1.cust_id LEFT JOIN ( SELECT order_num, sum(q...

2025-10-14

0 10

题解 | 返回顾客名称和相关订单号

SELECT cust_name, order_num FROM Customers cus INNER JOIN Orders on cus.cust_id = Orders.cust_id order by cust_name, order_num asc

2025-10-14

0 11

题解 | 从 Products 表中检索所有的产品名称以及对应的销售总数

SELECT prod_name, ( SELECT sum(quantity) FROM OrderItems as O where P.prod_id = O.prod_id ) quant_sold FROM Products as P

2025-10-13

0 12

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

SELECT cust_id, sum(item_price*quantity) as total_ordered FROM OrderItems O RIGHT JOIN Orders O2 on O.order_num = O2.order_num GROUP BY cust_id ORDER ...

2025-10-13

0 12

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

SELECT cust_email from( SELECT cust_id FROM OrderItems OI, Orders O where OI.prod_id = 'BR01' and OI.order_num=O.order_num ) as t1, Custom...

2025-10-13

0 13