尹煜

题解

/ 注册

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

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

#左关联 SELECT c.cust_name, o.order_num FROM Customers c LEFT JOIN Orders o USING(cust_id) ORDER BY c.c...

Mysql

2022-05-01

1 341

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

SELECT c.cust_name,t.order_num,t.OrderTotal FROM (SELECT i.order_num,o.cust_id,i.quantity*i.item_price OrderTotal &nbs...

Mysql

2022-04-28

0 354

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

SELECT p.prod_name,o.quant_sold FROM (SELECT prod_id,SUM(quantity) quant_sold FROM OrderI...

Mysql

2022-04-28

0 367

题解 | #返回购买价格为 10 美元或以上产品的顾客列表#

SELECT d.cust_id FROM OrderItems i,Orders d WHERE i.order_num = d.order_num AND i.item_price >=&n...

Mysql

2022-04-28

26 969

题解 | #确定 Products 表中价格不超过 10 美元的最贵产品的价格#

SELECT max(prod_price) max_price FROM Products WHERE prod_price <= 10

Mysql

2022-04-25

0 375