阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共128篇）

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

SELECT v.vend_id vend_id, COUNT(p.prod_id) prod_id FROM Vendors v LEFT JOIN P...

Mysql

2022-03-09

18 2218

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

SELECT p.prod_name prod_name, COUNT(oi.order_num) orders FROM Products p LEFT JOIN...

Mysql

2022-03-09

24 622

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

SELECT p.prod_name prod_name, oi.order_num order_num FROM Products p LEFT JOIN&nbs...

Mysql

2022-03-09

3 616

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

SELECT c.cust_name cust_name, o.order_num order_num FROM Customers c LEFT JOIN&nbs...

Mysql

2022-03-09

6 542

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

SELECT c.cust_name cust_name, o.order_num order_num FROM Customers c INNER JOIN&nb...

Mysql

2022-03-09

1 699

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

SELECT c.cust_name cust_name, tb.total_price total_price FROM Customers c INNER JOIN Orders o ON ...

Mysql

2022-03-09

5 1201

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

SELECT c.cust_email cust_email FROM OrderItems oi INNER JOIN Orders&nbs...

Mysql

2022-03-09

3 808

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

SELECT o.cust_id cust_id, o.order_date order_date FROM OrderItems oi IN...

Mysql

2022-03-08

4 701

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

SELECT c.cust_name cust_name, o.order_num order_num, SUM(oi.qu...

Mysql

2022-03-08

15 1362

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

SELECT cust_name, order_num FROM Customers c INNER JOIN&n...

Mysql

2022-03-08

2 480