少糖去冰啊_

分类

/ 注册

全部文章（共67篇）

题解 | 纠错4

SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, ...

2025-10-15

0 19

题解 | 组合 Products 表中的产品名称和 Customers 表中的顾客名称

SELECT prod_name FROM Products P1 UNION SELECT cust_name FROM Customers ORDER BY prod_name

2025-10-15

0 19

题解 | 将两个 SELECT 语句结合起来（二）

SELECT prod_id, quantity FROM OrderItems WHERE quantity = 100 or prod_id like 'BNBG%' ORDER BY prod_id asc

2025-10-15

0 19

题解 | 将两个 SELECT 语句结合起来（一）

SELECT prod_id, quantity FROM OrderItems O1 WHERE quantity = 100 union SELECT prod_id, quantity FROM OrderItems O2 WHERE prod_id like 'BNBG%'

2025-10-15

0 16

题解 | 列出供应商及其可供产品的数量

SELECT V.vend_id, count(prod_id) as prod_id FROM Vendors V LEFT JOIN Products P ON V.vend_id = P.vend_id GROUP BY V.vend_id ORDER BY V.vend_id

2025-10-15

0 21

题解 | 返回产品名称和每一项产品的总订单数

SELECT prod_name, count(order_num) as orders FROM Products P LEFT JOIN OrderItems O on P.prod_id = O.prod_id GROUP BY prod_name ORDER BY prod_name

2025-10-15

0 21

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

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 22

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

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 20

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

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 19

题解 | 返回购买 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 19